View Single Post
  #3   Report Post  
Jimbola
 
Posts: n/a
Default

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...