| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Conditional Formatting
I am trying to do conditional formatting of a few cells. The condition is:
Cell Value = #N/A and the format is to assign the background color to the font. But for some reason it doesn't work. The cells doesn't change. Any ideas what I'm doing wrong here? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with Conditional Formatting
Hi,
Use =ISNA(a1) wher a1 is the cell you are Conditionally formatting -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Ayo" wrote: I am trying to do conditional formatting of a few cells. The condition is: Cell Value = #N/A and the format is to assign the background color to the font. But for some reason it doesn't work. The cells doesn't change. Any ideas what I'm doing wrong here? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with Conditional Formatting
Thanks Mike.
"Mike H" wrote: Hi, Use =ISNA(a1) wher a1 is the cell you are Conditionally formatting -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Ayo" wrote: I am trying to do conditional formatting of a few cells. The condition is: Cell Value = #N/A and the format is to assign the background color to the font. But for some reason it doesn't work. The cells doesn't change. Any ideas what I'm doing wrong here? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Hybrid Mode
