Conditional Formatting Dates! NEED HELP :(

[ashleylabreck]

I have an old excel report that I created with conditional formatting as follows:

Column F showed the date an item was due in
Column E showed the date that we actually NEED it here

My formatting highlighted the cell in column F if the date was later than the cell in column E (meaning we need to expedite it).

My formula was: =$F2>$E2
It was applied to column F and it worked perfectly.

We have reformatted this report and now it has more columns and I noticed the my formatting was off so I went to redo it all.

When I applied this same formula, updating column references to reflect new column placement) I cannot get it to preform correctly... it seems to be highlighting completely randomly honestly...

Column G shows date item is expected to be delivered
Column F shows when we actually NEED the item here

I want to highlight the date in column G in yellow if this date falls later than the date in column F, this will highlight items that need to be expedited....


I have no idea why I cannot get this to work... it is the same exact situation as my first report... PLEASE HELP.

[daddylonglegs]

It was applied to column F....

Make sure the "applies to" range for that condition starts on row 2 to match the formula - otherwise the formatting will be out be a row

If you have to change the "applies to" range then that will sometimes also change your formula.....so change the "applies to" range first....and then change the formula back if required

[ashleylabreck]

Hey thanks! Great quick reply...

I went back and updated "applies to" range and then retyped the formula and it seems to work now... not sure exactly what happened... but you helped me get it, after trying for 3 hours today!!! HAHA ..

Thanks... ugh.. now back to work.