View original (French)

Color with IF function

michael -  
gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   -
Hello,

How to set the color or pattern of a cell using the IF function?

=IF(A1>2, red, blue)

2 answers

  1.
    13Myki13 Posted messages 8 Status Member 2
     
    Can you give me more details? I can't do it.
    2
    1. gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
       
      If you told us which version you are using, we could give you the procedure that is different between 2003 and 2007/2010.
      0
    2. 13Myki13
       
      I have version 2003.
      0
    3. gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
       
      Good evening,

      You select the cell to color:
      - format tab
      - select "conditional formatting"
      - condition 1 choose "the formula is"
      - next to it enter =A1>2
      - click on "format" and choose then validate "ok"
      0