Checked out Conditional Formatting:

Format Conditional Formatting

Set Condition 1 for Cell value is: less than
and Condition 2 Cell value is: greater than

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"mtishm" wrote in message
...
Hi Need help
new to all of this'

I trying to add color to a formula,if possible.
here is my formula
=if(c358,"J",if(c35<9,"L"))
if greater than 8 I want it to turn green, less than 8 i want it to turn
red.
--
Tish