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!

Conditional formatting does not set the Interior.Colorindex property.

You need to look at the FormatConditions for the cell.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Paul S Panoff" wrote in message ...
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!

Here's a link to a fairly complicated solution:

http://www.cpearson.com/excel/CFColors.htm



--
Message posted from http://www.ExcelForum.com