Forum Discussion

Lennox2525's avatar
Lennox2525
Copper Contributor
Mar 08, 2023

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 Mo...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Mar 08, 2023

    Lennox2525 

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

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

HansVogelaar's avatar
HansVogelaar
MVP
Mar 08, 2023

Lennox2525 

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

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

  • Lennox2525's avatar
    Lennox2525
    Copper Contributor
    Mar 14, 2023

    HansVogelaar  - Perfect Thankyou 🙂

  • GEEK_21's avatar
    GEEK_21
    Brass Contributor
    Mar 14, 2023
    for color maybe you can use the CountByFontColor function provided by kutools for excel