| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formating
I would like to use a set of conditional formats to fill a cell with a
particular color based on that cell having a numeric value only in it. If the cell is blank or contains text I want it to stay the original color so that if the value "..1" is entered it remains the original color but if ".1" is entered the cell will fill with 2nd color. Any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional formating
ISNUMBER(A15)
"Ryan" wrote: I would like to use a set of conditional formats to fill a cell with a particular color based on that cell having a numeric value only in it. If the cell is blank or contains text I want it to stay the original color so that if the value "..1" is entered it remains the original color but if ".1" is entered the cell will fill with 2nd color. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #N/A Conditional Formating | Excel Discussion (Misc queries) | |||
| Conditional formating | Excel Discussion (Misc queries) | |||
| Conditional formating | Excel Discussion (Misc queries) | |||
| conditional formating #N/A | Excel Worksheet Functions | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Linear Mode
