% Complete range in If statement how best to describe
I'm trying to have a conditional format occur in a status column, when the % Complete column hits a certain condition, for example:
1. If % Complete = 100%, place "Complete" in the Status Column, and conditional format will change to blue
2. If % Complete is less than 99% and greater than 1%, then place "In Progress" in the Status column, and conditional format will change to green
3. If % Complete is anything else, leave status blank
This is my formula, and I'm thinking I'm not representing the OR correctly, am I right? Keeps coming back as UNPARSEABLE
Help Article Resources
Check out the Formula Handbook template!