Austin Lang
Board Regular
- Joined
- Sep 10, 2021
- Messages
- 51
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
Hi all,
For some reason (possibly the amount of cold medicine in my system), I am having issues setting up the conditional formatting for this sheet and would greatly appreciate some help. These seem like an easy task, but for some reason, everything I do is wrong. I feel like I am having a syntax error somewhere. Let me set the scene..
All of this conditional formatting is for column F. Column F defaults to red prior to conditional formatting.
For some reason (possibly the amount of cold medicine in my system), I am having issues setting up the conditional formatting for this sheet and would greatly appreciate some help. These seem like an easy task, but for some reason, everything I do is wrong. I feel like I am having a syntax error somewhere. Let me set the scene..
All of this conditional formatting is for column F. Column F defaults to red prior to conditional formatting.
- If Column F is "Not Ready", red.
- If Column C is greater than 3, red.
- If Column C is between 1.00 and 1.99, orange.
- If Column C is between 2.00 and 2.99 and Column E is not "No" (This column will show date/time if a sanitize step has been re-conducted.), yellow
- If Column C is less than 1.00, green.