conditional formatting

Hi Everyone

I was wondering if you could help me. I have two columns of dates (AD and AE) I want to be able to turn the AD dates red if the AE date at the side of it is less than the AD date. Now I can do this on two cells side by side, but when I want to apply it to the full two columns its not working correctly. any ideas would be great.

thank you
Julie

Select AD1

Conditional Formatting
New Rule
Use a formula to determine...

=(AE1 < AD1)

format as required
Use Format painter (paintbrush icon) to copy to other cells

If these doesnt work you need to get Excel to check they are in fact dates.

Hi,

What's the CF you are using? The cell refs need to be relative and then applied to the whole range in Q. i.e.

Formula:

Please Login or Register  to view this content.

Not necessarily a good idea to apply formatting or Conditional Formatting to entire columns.

CF Formula:

Formula:

Please Login or Register  to view this content.

Regards, TMS

What's the conditional formatting rule for AD2 ?
Better still post your spreadsheet

That's not what you said at the beginning...

Originally Posted by Juls1965

if the AE date at the side of it is less than the AD date

Now you're saying it's the other way round

Originally Posted by Juls1965

if AD8<AE8

Decide what way round you want the condition to be

You also have MULTIPLE conditional formats set on those cells.
Delete all the multiple conditions and just add one condition:

Select AD1

Conditional Formatting
New Rule
Use a formula to determine...

=(AE1 < AD1)
(Amend if required as stated above)

format as required
Use Format painter (paintbrush icon) to copy to other cells

As has been said, you have reversed the requirement.

Whatever, see your updated sample workbook. You need to select all the cells from AD2 down to AD223 and use the formula:

Formula:

Please Login or Register  to view this content.

or

Formula:

Please Login or Register  to view this content.

if you want to highlight both cells.

Note that you need to make the column references absolute.


Regards, TMS

@iftikhar Hussain

Create a NEW thread for this and I'll answer it.
Don't hijack someone else's thread.

@iftikhar Hussain:

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

@Julie: You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.