B
Brian
I have a question about conditional formating. The way I understand CF is
that I can have 3 conditions and a "default." I have set mine up like this:
A1 80%
A2 60%
A3 0%
Condition 1
formula is =A10>=$A$1
Shades the cell Green
Condition 2
formula is =A10>=$A$2
Shades the cell Yellow
Condition 3
formula is =A10<$A$2
This works fine when the formula in A10 returns a number (most cases), but I
use the ISERROR() function to catch some Div/0 issues and replace them with a
text message (Usually "N/A"). In these situations, excel still formats the
cell Green, instead of the default of no shade, and I don't know why. Thanks
for any help.
that I can have 3 conditions and a "default." I have set mine up like this:
A1 80%
A2 60%
A3 0%
Condition 1
formula is =A10>=$A$1
Shades the cell Green
Condition 2
formula is =A10>=$A$2
Shades the cell Yellow
Condition 3
formula is =A10<$A$2
This works fine when the formula in A10 returns a number (most cases), but I
use the ISERROR() function to catch some Div/0 issues and replace them with a
text message (Usually "N/A"). In these situations, excel still formats the
cell Green, instead of the default of no shade, and I don't know why. Thanks
for any help.