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. 

​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.   Read More

​