Formula to change a cell

Occasional Contributor



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)

3 Replies
best response confirmed by Lennox2525 (Occasional Contributor)


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

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

@Hans Vogelaar  - Perfect Thankyou

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