IF function - Logical test

**TomBP** · 04-28-2010, 04:36 AM

Hi,

In attachment you will find that the word test is written in both black and red. If it is written in red I want a function to add OK to the cell next to it.

I believe an IF function can help me solve this. Is it possible to use the logical test to determine a color?

**DonkeyOte** · 04-28-2010, 04:46 AM

Originally Posted by TomBP

Is it possible to use the logical test to determine a color?

Only if the initial colour is itself determined by logic (rather than arbitrarily) else you need VBA. Differentiation based on formatting is ill advised for this very reason.

**sweep** · 04-28-2010, 04:48 AM

Hi,

You'll need a UDF such as this

Please Login or Register  to view this content.

to test the colour of the font.

=IF(fontcolour(A1)=3,"OK","")

**DonkeyOte** · 04-28-2010, 04:55 AM

And note that altering the font colour of any given cell(s) manually is not a volatile action - ie no recalculation will be invoked - you would have to invoke manually (even if the UDF is made volatile).

**Shridhar PS** · 04-28-2010, 05:17 AM

Originally Posted by DonkeyOte

And note that altering the font colour of any given cell(s) manually is not a volatile action - ie no recalculation will be invoked - you would have to invoke manually (even if the UDF is made volatile).

Alternativelly you can do the same with the help of "conditional formating"
path: home-conditional formating

regards

**sweep** · 04-28-2010, 05:42 AM

Alternativelly you can do the same with the help of "conditional formating"
path: home-conditional formating

I believe you'd still need to use a UDF in your conditional formatting. Regardless of where you put it, the UDF still needs a calculation to be invoked, or am I missing a trick?

**DonkeyOte** · 04-28-2010, 06:07 AM

Originally Posted by sweep

...or am I missing a trick?

No, not at all.

The mention of Conditional Formatting is in this context of no consequence whatsoever.

Conditional Formatting would only be relevant if applied to source values... this point has been covered previously, moreover there is nothing within the image uploaded that would allow us to determine the requisite logic for a Conditional Formatting based approach.