Hi,

I have a column of 7 cells, which return a value which will be between 0 and 400, but the cells themselves are formulae (e.g. G13 "=(C13*C$12)+(D13*D$12)+(E13*E$12)+(F13*F$12)").

I would like to conditionally format the column so that all cells in the column remain one colour (I happen to be using gold), but that whichever cell returns the greatest value of the 7 is formatted green.

Is this possible, or am I going to have to do it manually?

Many thanks!