conditional formatting by color and asterisks

[rrupp]

I want to conditionally format the fill of a cell to be red, if the font
color of the content of a cell is red AND another cell is equal (contains) 2
asterisks (**). Weird, I realize but can this be done?

So a cell will fill red if another cell's text is red and another cell has
** in it?

Any help would be appreciated.
Thanks!

 

[Pete_UK]

The problem here is that there is no standard function which can tell
you that the font colour of a cell is red, so you couldn't build a
condition for CF to work on.

You could set up a user-defined function to return the font colour
with a bit of VBA (examples on Chip Pearson's or Bob Phillips' sites),
but if you are going to do that you may as well use VBA to set the
colour and not use conditional formatting.

Hope this helps.

Pete