Excell 2013 - conditional formatting using a formula- apply rule [Solved/Closed]

Report
-
 Manos -
Hello,

I am trying to do the following :
A1:A100 ==> dates
B2:B100 ==> dates
1) apply conditional formatting to columns C1:BB1 if the contained date is in between A1 and B1 [can do that using a conditional rule with formula]
2) apply the respective rule to cells C2:BB2, ..., C100:BB100 [using the respective A2, ..., A100 and B2, ..., B100]

I cannot find a way other than do it one by one (...)

Thanks in advance,
Manos



1 reply

Posts
2744
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 10, 2021
460
Hi Manos,

First check your formula and remove the dollar symbol in front of all the row references (i.e. change $A$1 to $A1) . Then select your initial CF range C1:BB1 and drag it down as far as needed.

Best regards,
Trowa
Thanks Trowa.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!