Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating Question
Have a problem with conditional formating.
What I want it to do is if a cell has a zero input I want it to turn a color, but if the cell is left blank I want it to stay white, but whatever I'm doing Excel is reading a zero in a cell and a blank in a cell the same. Can anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating Question
Format / Cond Format / =AND(A1<"",A1=0)
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "terri" wrote in message ... Have a problem with conditional formating. What I want it to do is if a cell has a zero input I want it to turn a color, but if the cell is left blank I want it to stay white, but whatever I'm doing Excel is reading a zero in a cell and a blank in a cell the same. Can anyone help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating Question
Hi Terri
=AND(ISNUMBER(A1),A1=0) format to colour of choice. No need to do anything about blank, as you want the format to stay "as is" Regards Roger Govier terri wrote: Have a problem with conditional formating. What I want it to do is if a cell has a zero input I want it to turn a color, but if the cell is left blank I want it to stay white, but whatever I'm doing Excel is reading a zero in a cell and a blank in a cell the same. Can anyone help? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating Question
Thank you for the response. This will really help
"Roger Govier" wrote: Hi Terri =AND(ISNUMBER(A1),A1=0) format to colour of choice. No need to do anything about blank, as you want the format to stay "as is" Regards Roger Govier terri wrote: Have a problem with conditional formating. What I want it to do is if a cell has a zero input I want it to turn a color, but if the cell is left blank I want it to stay white, but whatever I'm doing Excel is reading a zero in a cell and a blank in a cell the same. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
Conditional Formating Extreme Question | Excel Worksheet Functions | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) |