Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format & Default Format Help
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format & Default Format Help
To tell you why, put some text (any text) in B2 and a number (any number) in
C2, and see what =B2C2 gives you. You can, of course, include a condition such as ISNUMBER(A10) in your CF criteria. Alternatively, if instead of writing text to A10 you merely write an error indication such as NA() [or #N/A] or #DIV/0!, then your condition when you compare with a number in A1 or A2 will return FALSE. -- David Biddulph "Brian" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
make a conditional format the default | Excel Discussion (Misc queries) |