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.
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 ?
© Copyright 2017 IDG UK. All Rights Reserved.