I have an excel sheet containing a variable number of columns (currently G3:AX30) I want to fill each cell with a colour (Red Yellow or Green) based on whether the cell value is higher than, the same as or lower than the value in the cell above it.
My initial attempts using CF in 2003 all seem to point at G3 and use this value as the conditon for applying the conditonal formatting instead of looking at the cell value and comparing it with the value in the cell above it.

Many thanks