Formula for Cell Color? 1

[jennuhw]

I have a spreadsheet that I need a formula or vb script. I have a formula in column L that is
=IF(I182="",(IF(J182="Not Found","X&quot)).
This part is working fine, but I need to find out the cell color . If it is a certain color, I need to change the row color. Thanks!

 

[xlhelp]

Please look at this thread

thread68-375744

 

[gibber17]

In the Excel Answer Wizard type in Cell Color and then click on Formulas as Formatting Criteria for examples of working with cell color.

 

[jennuhw]

I created the module, and place the =SCI(H2) in a cell. This let me to use the color value in the IF statment. Thanks!