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
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.
Excellent as usual, thank you, VoG™
This thread is now locked and can not be replied to.
Honor 9 Lite review
18 Best Adult Colouring In Books 2018
Les meilleures séries Netflix (2018)
© Copyright 2018 IDG UK. All Rights Reserved.