Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting test
I have a cell where font is black, but due to conditiona formatting the font
color is white. How do i test if font is white due to conditional formatting. I am trying If ActiveCell.ColorIndex = 3 Then End This does not work Sunil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting test
Hi,
To test the font colour use MyColour = ActiveCell.Font.ColorIndex But this won't return the font colour if that colour is set by conditional formatting. It can be done and I recall there is a method on the XLdynamic web site but it's not easy. Why don't you test for the condition that causes the format colour white from which you can infer the colour of the font. Mike "Sunil Patel" wrote: I have a cell where font is black, but due to conditiona formatting the font color is white. How do i test if font is white due to conditional formatting. I am trying If ActiveCell.ColorIndex = 3 Then End This does not work Sunil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - Test Practice | Excel Discussion (Misc queries) | |||
conditional formatting test | Excel Programming | |||
Conditional formatting to test blank text cell | Excel Worksheet Functions | |||
Conditional Formatting to Test Value in Cell | Excel Worksheet Functions | |||
Multiple-Test Conditional Formatting | Excel Discussion (Misc queries) |