View Single Post
 
Old 11-28-2008, 02:39 AM
leroytrolley leroytrolley is offline
Novice
 
Join Date: Jul 2008
Posts: 11
leroytrolley is on a distinguished road
Default 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.
Reply With Quote