SOLVED

# Formula to change a cell

Copper Contributor

# 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)

3 Replies
best response confirmed by Lennox2525 (Copper Contributor)
Solution

# Re: Formula to change a cell

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

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

# Re: Formula to change a cell

@Hans Vogelaar  - Perfect Thankyou :)

# Re: Formula to change a cell

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

Accepted Solutions
best response confirmed by Lennox2525 (Copper Contributor)
Solution

# Re: Formula to change a cell

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

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