Hi there,
If a cell cntent includes a symbol [as an arrow, for instance] beside the text,the font colour does not change as required when the condition is met.
Please see the attached sample.
Thanks in advance.
Hi there,
If a cell cntent includes a symbol [as an arrow, for instance] beside the text,the font colour does not change as required when the condition is met.
Please see the attached sample.
Thanks in advance.
Last edited by Michael6; 10-03-2009 at 05:02 PM.
For some reason some of the cells have partial formatting.
Select the range and set the Font colour to automatic. CF should now work as expected.
Andy Pope,
You are quite right; your answer saved me a lot of trouble trying to figure out what the hell might be the couse of the problem. Thank you very much.
The problem is now solved
Last edited by Michael6; 10-03-2009 at 05:04 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks