Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi all
I am not sure if this is possible but I have a spreadsheet with two columns of dates. If the date in one column is less than the one in the other column I want to highlight the column in a different colour. However the dates are all different Example 12/04/05 13/05/05 04/01/05 13/04/05 05/05/05 03/03/05 Therefore I have tried to put an if statement in the conditional formatting but it gives me an error. I could create a separate IF statement column but this becomes a bit clumsy (there's actually loads of dates on different sheets) Therefore in summary I want to create conditional formatting on one column based on the values in another column. Is this possible? any help greatly appreciated Rexmann PS running Excel XP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |