•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
Tagged with
#machine learning in spreadsheet applications
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#cloud-based spreadsheet applications
#AI formula generation techniques
#self-service analytics tools
#Excel compatibility
#financial modeling with spreadsheets
#formula generator
#Excel alternatives
#self-service analytics
#conditional formatting
#machine hours
#intervals
#formula
#reset counter
#service
#logging