Use conditional formatting from the format menu. It will allow you to alter
the format of a cell for three different conditions.

Regards...

"Steve" wrote:

Is there a way to change the colour of a cell as part of a formula

ie: =IF(SUM(F5:F8)<100, change the colour of
cell,IF(SUM(F5:F8)=100,100),SUM(F5:F8))
Thanks for any help I can get

Steve