not good at macro but you can do it by using option Format/conditional
formatting. this one limits to max 3 conditions.
--
sr


"Flash" wrote:

Hi

I would like to colour a sum cell - ie forecast less Actual

if the Actual is greater than forecast 105% I want the cell to be red

if the Actual is less than forecast < 95% I want the cell to be green

if the actual v forecast is close - between 95% and 105% then the cell
should be white

if someone can help we with this it would be great. Thanks