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 ...
SergeiBaklan
Nov 02, 2017Diamond 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