•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formatting in a single cell based on which interval it is in
Hi all
I have a sheet where we log our machine hours (how many hours a specific machine has run for)
I want to create a conditional formatting based on whether the machine has run 0-200 hours(green), 200-350 hours (yellow) or 350-500 hours (red)
Hours will continually go up, so I'm either looking for a formula/formatting to recognise these intervals (eg 7250 = yellow, but also 8250=yellow), or only the fixed intervals but with a way to "reset" the counter after a service has been done to the machine.
Hope this makes some sort of sense!
[link] [comments]
Want to read more?
Check out the full article on the original site