Conditional Formatting Based on Font Color

[skmerrey]

Hi Everyone,

I was hoping there is a way to use CF based on the font color of another Cell.

e.g. fill A1 green if B1 font color is black or
fill A1 red if B1 font color is grey.

I had a wild guess and tried using the "use formula to determine which cells to format" and used this formula "=B1=Font.Color = RGB(0, 0, 0)". But no luck.

I'm working with 2 font colors RGB(0, 0, 0) and RGB(140, 140, 140).

Can this be done?
Thanks for any help.
shaun

 

[Shteven]

Is the font color in column B determined by a rule that can be converted to conditional logic? If so, you can apply the same logic to both sets of cells (font color in B and fill color in A).

 

[skmerrey]

Hey,

No rules, I'm just manually changing the font color and I need the CF to detect that.

 

[Shteven]

I'm pretty sure the answers in this thread can help:
http://chandoo.org/forum/threads/sum-based-on-cell-color.29105/

 

[Hui]

CF are used to set Font Color but cannot read it

What is the Logic you use to set the Font Colors?
That could be applied to the CF's if you can describe it

You could also add another field "Font Color" and use a User Defined Function to display the color's Number, That could then be used in the CF

I'd strongly recommend the former technique