Excel and conditional formatting (I think)

  exdragon 09:48 19 Jun 2010
Locked

Hi - I've tried every combination of conditional formatting, but can't work this out:

I've got 2 columns, Q contains a date when a payment is due, in the format 20/06/10 and S is the date the payment is received.

All I want to do is to get the relevant cell in Q to change font colour when I enter the date in the corresponding cell in S.

I would have thought that if Q is not equal to a blank cell, then that would work, but it doesn't.

Any help available, please?

Thanks

  VoG II 10:18 19 Jun 2010

Select the cells in column Q. Assuming that you are starting in row 1 use the CF formula

=S1<>""

set a format and OK your way out.

  exdragon 10:49 19 Jun 2010

Excellent as usual, thank you, VoG™

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Best of the Grad Shows 2017: UAL Central Saint Martins

MacBook Pro 15-inch (2017) review

Comment connecter un MacBook à une TV ?