Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Referencing problem when copying conditional formatting
(Excel 2000)
I have a row of cells (K6:AH6) which have some conditional formatting, depending whether or not the date (month and year) shown in the corresponding headers in K5:AH5 are less than or greater than (up to 12 months) the date given in cell D6. I have managed to get this working for one row, using the following formula: For the months that are less than the given date in D6 (up to 12 months previous): =AND(DATE(YEAR(K5),MONTH(K5),28)<DATE(YEAR($D$6),M ONTH($D$6),28),DATE(YEAR(K5),MONTH(K5),28)DATE(YE AR($D$6)-1,MONTH($D$6)-1,28)) For the months that are greater than the given date in D6 (up to 12 months): =AND(DATE(YEAR(K5),MONTH(K5),28)DATE(YEAR($D$6),M ONTH($D$6),28),DATE(YEAR(K5),MONTH(K5),28)<DATE(YE AR($D$6)+1,MONTH($D$6)+1,28)) When I copy this down to the other rows, the cell reference changes where a '$' has not been entered in the formula - so the references for the headers then changes to subsequent rows. However, I change the formula to how I think it should be represented, the conditional formatting doesn't work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Conditional Formatting | New Users to Excel | |||
Excel 2003 print problem with conditional formatting cell selected | Excel Discussion (Misc queries) | |||
Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
Copying Conditional Formatting | Excel Discussion (Misc queries) | |||
copying conditional formatting | Excel Worksheet Functions |