Forum Discussion

rakshat2's avatar
rakshat2
Copper Contributor
Nov 09, 2022

Using the IF formula to change a cell's Color

I want to change the color of cell using multiple if. For example, if marks are <60 the cell color would be red. if marks>=60 and marks<75 then cell color would be Yellow and if Marks>=75 then it would be green. I don't want to use conditional formatting.

 

  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor

    Hi rakshat2 

     

    the only regular way to achieve this is using conditional formatting. If you don't want to use it, you would need to use VBA. 

Resources