kevinc1973
New Member
- Joined
- Jun 20, 2019
- Messages
- 22
Good morning all,
I am working on a spreadsheet in Google sheets and I would like to do conditional formatting on a cell. I have 2 cells c5 and n5, n5 is the milage of last time the truck went in for a pm. C5 is when the truck went in for a certain repair. I would like to change the cell c5 to yellow when it gets within 1500 miles of the last time it was in for a pm and red when it is equal to or greater than the last time it was in. I would also need it to stay white if it is more than 1500 miles from the last pm. Any ideas everything I tried it seems to cancel each other out. It is most likely the way I am wording the formulas but thanks in advance.
Kevin
I am working on a spreadsheet in Google sheets and I would like to do conditional formatting on a cell. I have 2 cells c5 and n5, n5 is the milage of last time the truck went in for a pm. C5 is when the truck went in for a certain repair. I would like to change the cell c5 to yellow when it gets within 1500 miles of the last time it was in for a pm and red when it is equal to or greater than the last time it was in. I would also need it to stay white if it is more than 1500 miles from the last pm. Any ideas everything I tried it seems to cancel each other out. It is most likely the way I am wording the formulas but thanks in advance.
Kevin