Cell Colour Change Within an if Function

[Alex]

How do I make a certain cell coloured within an if
statement i.e.

if L4<=3
if true: Green
if false: Red
the question is how do I make the cell become green or
red in colour instead of the word green or red being
inserted into the cell.

 

[Roger Govier]

Hi Alex

Format=>Conditional Formatting=> choose drop down to select Formual is
In the white pane type =L4<=3
Choose Format=>Patterns=>Green
Click on Add
In white pane type =L4>3
Format=>Patterns=>Red