Yes you can, look for Conditional Formatting in Help
"K" wrote in message
...
can i colour a cell on basis of results of a formula e.g clour blue a cell
if
resulting value from a formula is a specific value

fo exapmle if a formula returns a value 50 then automatically this cell
is
colored blue but if this value is <50then this cell color is red