Formula to change a cell

[Lennox2525]

Hi, 

Based on what is in the total box. I need to create a formula for the outcome:

less or equal to 20  = outcome will be Bi-Monthly (colour Green)

in between 20 and 70 = Outcome will be Monthly (Colour Amber)

greater or equal to 70 = Weekly  (Colour Red)

[#2 · Accepted solution]

@Lennox2525 

=IF(total<=20, "Bi-Monthly", IF(total<70, "Monthly", "Weekly"))

You can use conditional formatting to color the cell based on its value.

[#3]

@Hans Vogelaar  - Perfect Thankyou

[#4]

for color maybe you can use the CountByFontColor function provided by kutools for excel