Excel 2003 cell colour change [Closed]

Report
-
Hello,
I'm new to using programming but below is what i need to happen

if the value of one cell is equal to or greater then another i need a range of cells to change colour.

eg. if d8 >= f8 then cells a8:f8 change to red

the other issue i am dealing with is that in some cases i need it to work over a group of cells

eg. if d8:d10 >= f8:f10 then a8:f10 change to red

any help would be so helpful as i am flying blind here

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!