Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting not applied to data exported from Access
Hi
I have an MS Access report that I copy+paste into an excel worksheet. Other cells in the worksheet contain conditional formatting which lookup the cells with the access data (date: dd/mm/yyyy) and compares against a date in two other cells and shades the cell appropriately. The problem is not the formula - it works fine - but that the conditional formtting does not work on the data exported from Access but only works if I manually type in a date. However, I cannot see ANY difference between an manually tpyed in date and the Access exported date. Help please! Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Refreshing Access data in Excel | Excel Discussion (Misc queries) | |||
How do I use conditional formatting for multiple rows? | Excel Worksheet Functions |