I am trying to gets cells to turn red if the number in the cell is
above 20 but I can get it to work using conditional formating - what
am i doing wrong ? or cant it be done that way ?

Johnny