| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - 2 conditions
Excel 2003
The cell to conditionally format is a reference name. The reference name will not always be valid I would like to format on 2 conditions, one as an error (to format as blank) when the reference name does not exist, and second to format without the error. I am successful on the first condition with the following: Formula Is =ISERROR(#NAME?) with font color of white I can not get the second condition to work. Nothing I have tried overrides the first condition. (The referenced name is valid, but formatting does not change.) Any suggestions on what the second condition would like? -- Appreciate your help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting - 2 conditions
Assuming you are trying to highlight cell A1
=ISERROR(#NAME?) is always true hence your second condition is not being evaluated use =ISERROR(A1) it will be true if A1 has #NAME? error, false otherwise "LorrieM" wrote: Excel 2003 The cell to conditionally format is a reference name. The reference name will not always be valid I would like to format on 2 conditions, one as an error (to format as blank) when the reference name does not exist, and second to format without the error. I am successful on the first condition with the following: Formula Is =ISERROR(#NAME?) with font color of white I can not get the second condition to work. Nothing I have tried overrides the first condition. (The referenced name is valid, but formatting does not change.) Any suggestions on what the second condition would like? -- Appreciate your help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting - 2 conditions
Worked Great - Thanks
-- Appreciate your help! "Sheeloo" wrote: Assuming you are trying to highlight cell A1 =ISERROR(#NAME?) is always true hence your second condition is not being evaluated use =ISERROR(A1) it will be true if A1 has #NAME? error, false otherwise "LorrieM" wrote: Excel 2003 The cell to conditionally format is a reference name. The reference name will not always be valid I would like to format on 2 conditions, one as an error (to format as blank) when the reference name does not exist, and second to format without the error. I am successful on the first condition with the following: Formula Is =ISERROR(#NAME?) with font color of white I can not get the second condition to work. Nothing I have tried overrides the first condition. (The referenced name is valid, but formatting does not change.) Any suggestions on what the second condition would like? -- Appreciate your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting - more than 3 conditions | Excel Discussion (Misc queries) | |||
| Conditional Formatting--Need 4 conditions | Excel Discussion (Misc queries) | |||
| Need 6 Conditions / Conditional Formatting | Excel Worksheet Functions | |||
| Need more than 2 conditions in Conditional Formatting | Excel Worksheet Functions | |||
| conditional formatting with four conditions | Excel Worksheet Functions | |||
Linear Mode
