Forum Discussion
Formula to change a cell
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)
=IF(total<=20, "Bi-Monthly", IF(total<70, "Monthly", "Weekly"))
You can use conditional formatting to color the cell based on its value.
=IF(total<=20, "Bi-Monthly", IF(total<70, "Monthly", "Weekly"))
You can use conditional formatting to color the cell based on its value.
HansVogelaar - Perfect Thankyou 🙂
- for color maybe you can use the CountByFontColor function provided by kutools for excel
