Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting by color and asterisks
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting by color and asterisks
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 On Aug 6, 7:21*pm, rrupp wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I put the intermitent color with conditional formatting | Excel Worksheet Functions | |||
Conditional formatting to color cells | Excel Discussion (Misc queries) | |||
Conditional Formatting on Color | Excel Worksheet Functions | |||
Color Conditional Formatting | Excel Worksheet Functions | |||
Conditional color formatting entries have wild color. | Excel Discussion (Misc queries) |