Excell 2013 - conditional formatting using a formula- apply rule

Manos - Mar 24, 2015 at 09:46 AM
 Manos - Mar 26, 2015 at 02:48 AM

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,


1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Mar 24, 2015 at 12:23 PM
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,
Thanks Trowa.