Excel and conditional formatting (I think)

  exdragon 09:48 19 Jun 10
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 10

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 10

Excellent as usual, thank you, VoG™

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

Sony Xperia XZ Premium review: Hands-on with the new 4K HDR phone with Motion Eye camera and Snapdr5…

1995-2015: How technology has changed the world in 20 years

Best laptop for design and art 2017: we test Apple, Dell, HP, Lenovo and Microsoft's best models…

CarPlay tips & troubleshooting guide: CarPlay tips & troubleshooting guide: Get the most from…