Fill cell colour based on value

[bd528]

I have a selected range of cells. I need code to go through each cell in the selection, and if the cell's value is "1" then fill the cell green, and if the cell is blank, then fill the cell red.

Conditional formatting isnt an option in this case.

If anyone has any ideas, I'd be most grateful. Thanks in advance.

[royUK]

Why is Conditional Formatting not an option?

[bd528]

Why is Conditional Formatting not an option?

Excellent question, and now that i think about it, conditional formatting is now an option!

I've got the "1" cells green. How do I get the blank cells red? I cant see an option to conditionally format if a cell is empty.

Thanks!

[royUK]

Cell Value = ""

[bd528]

Thanks for that.

I've now remembered why I initially ruled out conditional formatting.

Now that the cells are green and red, I want to remove the "1"s and leave their cells green, but if the "1"s go, so will the formatting.

How can I get round this?

[NBVC]

Can you format the font of the cell, along with the background to be the same colour so you don't actually see the 1, although it is really there?

[royUK]

Alternatively have a hidden column that controls the Conditional Formatting

[bd528]

2 great ideas. Thanks a lot!

Solved!