Help- conditional cell formatting
Solved/Closed
campbellty10
Posts
2
Registration date
Monday 20 November 2017
Status
Member
Last seen
21 November 2017
-
20 Nov 2017 à 12:56
campbellty10 Posts 2 Registration date Monday 20 November 2017 Status Member Last seen 21 November 2017 - 21 Nov 2017 à 09:13
campbellty10 Posts 2 Registration date Monday 20 November 2017 Status Member Last seen 21 November 2017 - 21 Nov 2017 à 09:13
Related:
- Help- conditional cell formatting
- Excel clear formatting - Guide
- Excel conditional formatting based on date - Guide
- Conditional formatting if cell contains text ✓ - Excel Forum
- Conditional format range if one cell contains certain text - Excel Forum
- Based on the cell values in cells b77 ✓ - Excel Forum
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
20 Nov 2017 à 13:27
20 Nov 2017 à 13:27
21 Nov 2017 à 09:13
I actually had that part in the blue area, I ended up needing to change the formula to match yours.
Looks like I needed to go to new rule and actually write out the formula instead of setting it up through the "greater than" and "less than" buttons under the conditional formatting drop down.
Thanks!