1 min readfrom 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!

submitted by /u/Askebon
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article