Excel and conditional formatting (I think)

  exdragon 09:48 19 Jun 2010

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?


  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


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

Huawei MateBook X Pro review: Hands-on

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?