M
mptyler
I have a work sheet with rows of transaction data. One of the columns
contains the date for each transaction. Every transaction date should be
greater than or equal to any transaction above it on the table, i.e. with a
lower row number. Many (but not all) transactions are similar to prior
transactions. When this happens I copy the prior transaction and paste it
into the next available row and revise the date field. In order to call out
a date error, I use conditional formatting to highlight cells with incorrect
dates. In Excel 2003 it was easy using two conditions: 1. =F2>=F1 [no
format] 2. =F2<F1 [highlight] In Excel 2007, the F1 row is highlighted if
condition 2 is true, not the F2 row. Also every time I copy and paste an
earlier transaction two new formatting rules are generated. After a while
Excel slows down considerably until I delete the spurious rules.
contains the date for each transaction. Every transaction date should be
greater than or equal to any transaction above it on the table, i.e. with a
lower row number. Many (but not all) transactions are similar to prior
transactions. When this happens I copy the prior transaction and paste it
into the next available row and revise the date field. In order to call out
a date error, I use conditional formatting to highlight cells with incorrect
dates. In Excel 2003 it was easy using two conditions: 1. =F2>=F1 [no
format] 2. =F2<F1 [highlight] In Excel 2007, the F1 row is highlighted if
condition 2 is true, not the F2 row. Also every time I copy and paste an
earlier transaction two new formatting rules are generated. After a while
Excel slows down considerably until I delete the spurious rules.