See Chip's site.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP

On Thu, 10 Feb 2011 18:50:32 -0800 (PST), c1802362 wrote:

Hello group.

Came across a situation today which I couldn't resolve to my
satisfaction. Maybe someone here can help...

A colleague needed me to code a spreadsheet with a fairly simple
requirement. If a certain cell was green, the entire row would be
colored green; if the cell was red, the entire row would be shaded
red. The issue is the cell I'm basing everything off of is
conditionally formatted. Trying to recognize the cell's color via
cell.interior.colorindex does not work.

I was unable to get any code to recognize the conditionally formatted
cell. I finally resolved my problem by eliminating the conditional
formatting and hardcoding the conditionally formatted formulas into
the VBA module.

So, does anyone know of a method to get VBA to recognize a
conditionally formatted cell?

Art