Cell Colour Change Within an if Function

  • Thread starter Thread starter Alex
  • Start date Start date
A

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.
 
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
 
Back
Top