Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting & interior color
I have a cell defined with a conditional format that when the value is
<0 the cell is filled in Yellow. After the form has been completed by the user, they press a "Done" button. The button has code to check for errors. I was trying to check for errors by looking for yellow cells but have not been successful. Here is the code I'm using. If Worksheets("Kern Form").Range(Cells(RowIndx, ColIndx), Cells(RowIndx, ColIndx)) _ .Interior.ColorIndex = 6 Then <-- using this there is never an error ' .FormatConditions(1).Interior.ColorIndex = 6 Then <-- using this there is always an error ErrorFnd = True End If What SHOULD I be checking? Thank You all in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
color the interior of a range | Excel Worksheet Functions | |||
Print without Interior Color | Excel Discussion (Misc queries) | |||
interior.colorindex used with conditional formatting | Excel Worksheet Functions | |||
Interior Cell color | Excel Programming |