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

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

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

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:

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


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

http://www.thecodecage.com/forumz

Shading cells that contain formulas and conditional formatting atthesame time.
 

On 7 Jun., 15:49, FreeBird wrote:
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:

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

--
FreeBird
------------------------------------------------------------------------
FreeBird's Profile:http://www.thecodecage.com/forumz/member.php?u=1701
View this thread:http://www.thecodecage.com/forumz/sh...d.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