ExcelBanter - Conditional Formating Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Formating Question (https://www.excelbanter.com/excel-discussion-misc-queries/56840-conditional-formating-question.html)

terri

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?

Ken Wright

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?

Roger Govier

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?

terri

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?

All times are GMT +1. The time now is 05:48 AM.