Using Conditional Formatting IfError

[andrewb90]

Hello All,

I am using an IFERROR formula to accurately format my cells, however, I would like to have a flag icon appear instead of highlighting the cell, and I am struggling to properly do it.

Is this even possible?

Here is the current formula:

=ISERROR(S90)

Thanks,

Andrew

 

[FDibbins]

What does your data look like?
What are you testing for?
When do you want the CF rule to apply?

 

[andrewb90]

The data is all in time format (for making a work schedule) an error would appear in my totals line if say the letter "Q" were entered instead of a time.

The formatting needs to appear if an error appears in S90.

I can currently make my selected cell highlight or change font color, but I want a cell icon to appear, but when I try to put a formula in excel doesn't seem to accept it.

 

[FDibbins]

I can currently make my selected cell highlight or change font color, but I want a cell icon to appear, but when I try to put a formula in excel doesn't seem to accept it.

Icon formatting does not accept formulas