Formatting - conditional on errors

Denise · Feb 20th, 2002, 04:08 PM

I would like to use conditional formats that kick-in when a cell's formula results in an error. Is there a way to do this?

Denise

DRJ · Feb 20th, 2002, 04:11 PM

Try using a function like iserr or isna depending on what errors you want or if you want all error. Then make the conditional format have (Formula Equals) then something like =IsErr("A1")

HTH

DRJ

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 04:08 PM	#1
Denise New Member Join Date: Feb 2002 Location: M&T Bank Posts: 18	I would like to use conditional formats that kick-in when a cell's formula results in an error. Is there a way to do this? Denise

Feb 20th, 2002, 04:11 PM	#2
DRJ MrExcel MVP Join Date: Feb 2002 Location: California Posts: 3,857	Try using a function like iserr or isna depending on what errors you want or if you want all error. Then make the conditional format have (Formula Equals) then something like =IsErr("A1") HTH DRJ