Forum Discussion
Conditional Formatting Help
Below average background in Excel, I barely understand how to add basic formulas into spreadsheets. But I'm trying to make a simple excel sheet for one of my coworkers to help track when our company vehicles need and oil change. I've figured out how to get basic greater than or less than formulas to fill cells, but what I'm trying to do is get a cell to change color when the value is 10,000 miles over the last oil change listed. My idea is to set Vehicle numbers and names into Column A, Last Oil Change in B, and Current Mileage in C. When the value of column C is < 10000 of the value in column B I want conditional formatting to turn that cell red. Is this possible? Thanks in advance.
- derricks1675Copper Contributor
Thats exactly what I needed, I ended up just copy/pasting the formula and setting it up for 25 vehicles and it works perfectly. Thanks! SergeiBaklan
derricks1675 , you are welcome