you dont need the "if" just the result so say you have =if(a1=100,"yes",if(a1=200,"no","maybe")
and you wanted green for yes, red, for no an orange for maybe
the cf would be =a1=100 green =a1=200 red and colour the cell with the format orange