Code for Changing Cell Backgrounds
Sorry about the trivial title but...
I need to be able to compare to figures in different cells, and if one is larger than the other fill the cell with a red background.
Something along the lines of
if cell a1 is greater than cell b1
then
make a1 red
else
make cell a1 green
I will need to copy the same formula in to other cells too.
Thank you.
|