conditional formatting, empty cells

  • Thread starter Thread starter spolk
  • Start date Start date
S

spolk

Hi faced to the following problem: Let us asssume that i want to c fin
all values in column A with range 3 to 9 and make them red.

Everything goes fine when I select the whole column, go to th
conditional formatting and use the system: if cell value is not betwee
0-9 make the cell red. The blank cells are not colored

BUT: when I use the same system with values between 3-9, the empt
cells are colored to red and system is not working.

Can anyone explain why this system is working from 0 to eternity an
not from 1 to eternity..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top