Shading cells that contain formulas and conditional formatting at thesame time.

A

andreashermle

Dear Experts:

I got cells in one table of a worksheet that contain ...

.... formulas as well as conditional formatting (i.e. there are cells
that contain both attributes)

I would like to fill these cells (containing formulas as well as
conditional formatting at the same time) with a certain shadefill (RGB
177, 177, 177) with the aid of a VBA macro.

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
 
F

FreeBird

Hello,


Union(Cells.SpecialCells(xlCellTypeFormulas, 23)
Cells.SpecialCells(xlCellTypeAllFormatConditions)).Interior.Color
RGB(0, 255, 0)

you may have to complete the formula selection.

bye
 
A

andreashermle

Hello,

Union(Cells.SpecialCells(xlCellTypeFormulas, 23),
Cells.SpecialCells(xlCellTypeAllFormatConditions)).Interior.Color =
RGB(0, 255, 0)

you may have to complete the formula selection.

bye

andreashermle;739265 Wrote:



Dear Experts:






--
FreeBird
------------------------------------------------------------------------
FreeBird's Profile:http://www.thecodecage.com/forumz/member.php?u=1701
View this thread:http://www.thecodecage.com/forumz/showthread.php?t=207509

http://www.thecodecage.com/forumz


Hi FreeBird,

thank you very much for your professional help. Exactly what I wanted.
Great job.

Regards, Andreas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top