Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting and ISBLANK
I can not figure out how to do this...is it possible?
I am trying to use conditional formatting to color a cell if it is blank. Then, when filled with a number it changes to white, including a 0. I need the 0 to show if it is input. When I try to get it to work with the Isblank statement, it changes the blank cell to white, even though there is not data in there. I know it is because it is reading a zero, but I can't figure out how to get past it... |
#2
|
|||
|
|||
What formulae are you using?
-- HTH RP (remove nothere from the email address if mailing direct) "Amanda" wrote in message ... I can not figure out how to do this...is it possible? I am trying to use conditional formatting to color a cell if it is blank. Then, when filled with a number it changes to white, including a 0. I need the 0 to show if it is input. When I try to get it to work with the Isblank statement, it changes the blank cell to white, even though there is not data in there. I know it is because it is reading a zero, but I can't figure out how to get past it... |
#3
|
|||
|
|||
instead of using isblank use formula is =A1=""
"Amanda" wrote: I can not figure out how to do this...is it possible? I am trying to use conditional formatting to color a cell if it is blank. Then, when filled with a number it changes to white, including a 0. I need the 0 to show if it is input. When I try to get it to work with the Isblank statement, it changes the blank cell to white, even though there is not data in there. I know it is because it is reading a zero, but I can't figure out how to get past it... |
#4
|
|||
|
|||
Perhaps tinker with this:
Select col A Click Format Conditional Formatting For Condition 1, set it as: Formula Is: =AND(A1<"",ISNUMBER(A1)) Format Patterns tab Light brown? OK Click OK at the main dialog Test it out by entering into col A: some numbers, including zero, some text as well, etc. The CF will trigger only if the cell contains something and that something is a number. Text (including text numbers entered with a preceding apostrophe) should *not* activate the CF. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Amanda" wrote in message ... I can not figure out how to do this...is it possible? I am trying to use conditional formatting to color a cell if it is blank. Then, when filled with a number it changes to white, including a 0. I need the 0 to show if it is input. When I try to get it to work with the Isblank statement, it changes the blank cell to white, even though there is not data in there. I know it is because it is reading a zero, but I can't figure out how to get past it... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|