Conditional Formatting Returns a No Cells Found Message

[nhbartos]

Hi again...

I search the forum for an answer, but could not find one.

I am simply trying to conditionally format cells to change fill color based on condition.
When I select any cell, ones with numbers, formulas, or blank, I get a "No Cells Found" error message.

Any thoughts?

 

[etaf]

what version of excel

how are you using conditional formatting - entering a formula
at what point do you get the error ?

 

[nhbartos]

Excel 2007
The cells are populated with the formulas.
I am then highlighting the cells, clicking on conditional formatting, then the error comes up.
Now, this is happening on the entire worksheet, populated or not.

 

[nhbartos]

UPDATE: Might have found it...

I was going to the Find & Replace toolbar and selecting conditional formatting there...all set!
Thanks again!

 

[etaf]

glad you resolved