Hi K

Look on Debra's site for a CF example
http://www.contextures.com/xlCondFormat01.html

--
Regards Ron de Bruin
http://www.rondebruin.nl


"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