Conditional Formatting - Blank cell fill problem....

[LDouble3]

Hi,

When i conditional format column C and i want the rules:

0% to 49% fill Red
50% to 90% fill Amber
91% to 100% fill Green

All cells below that are blank in this column fill Red as it uses the zero. How can i stop this from filling Red?

Thanks in advance.

[LDouble3]

I am unsure how to upload the sample spreadsheet for you to view, what site can be used to upload to?

[LDouble3]

Conditional formatting Blank cell issue.xlsx

There we go spreadsheet attached ...

[Tanya1]

In conditional formatting use
Navigation:
new rule->Format only cells that contains->In first tab you will find tab cell value.
from drop down select BLANKS and set format to fill with white.
Hope it will help

[LDouble3]

This does not work, i have put the cond format in blanks are no fill, then put in that between 0 to 20 are to be Red and it fills all blanks Red.

Please see attached up to date S/S

[crispybadger]

Hi,

What Tanya is saying works for me. I had a look at your rules and you need to select, white etc.

I know it starts off as showing blank when you open the cond format, but you need to select white etc

[LDouble3]

Once i put in a between 0-20 rule all blank cells change to the fill of this rule

[crispybadger]

Try the attached, let me know if this is any good?

Cheers

[crispybadger]

Try the attached, let me know if this is any good?

Cheers

P.S - When you need to expand the columns, just change the range to suit

[LDouble3]

This doesnt seem to match what i am looking for.

I want the cells to fill with the parameters set and just not fill the blanks in with colour because it see's this as a 0

[crispybadger]

This doesnt seem to match what i am looking for.

I want the cells to fill with the parameters set and just not fill the blanks in with colour because it see's this as a 0

I am lost. I thought what I done fulfilled exactly what you wanted??

Maybe upload what it should look like then we can take it from there

Cheers