Forum Discussion
Sara Whitney
Nov 02, 2017Copper Contributor
Excel Functions
Hey there! I'm really new to Excel and I am trying to track my stats at work and I need to use an IF function but I'm not sure how to do it. I would like it so for example, if my TB% is 82% or higher the cell is green or if it is 81% or lower it is red. Any help would be appreciated :) Thank you!
1 Reply
- SergeiBaklanDiamond Contributor
Hi Sara,
Built-in conditional formatting https://support.office.com/en-us/article/Use-formulas-with-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f with two rules, one for green color (TB>0.82) and one for red one (TB<=0.81) could be a solution