cell formatting with colors

[Jainsworth2007]

I have a table that I need to have the cells color change to red when it's populated with a number = or > .30. I've seen it done before but can't remember how. Please could someone help?

[pike]

No problems
select the cell then Conditional formating
Select formula and enter =>0.3
and select the format colour
hope it helps