I have a worksheet that contains the dates /days of the month in a row header (a single row using 31 columns for each day of the month) and asset numbers in a single column on the left. Next to this column of assets is a column reserved for mileage "starting" and "ending". Since I am using starting and ending mileage in two cells on top of other I merged the asset column cells into a single cell for a single entry (i.e. 29332, 49563, etc.) The intent of this worksheet checks to make sure the starting value for the next day matches the ending value for the previous day. If the entries do not match conditional formatting highlights the two cells forcing the user to readjust the entry to clear the worksheet and /or find out why there is a discrepancy in the mileage reported by the driver. Is it possible to use conditional formatting in this format?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional formatting based on preceding cell in a series of columns
- Thread starter linesite
- Start date
Similar threads
