Hello Friends,
I am looking for an easier way to use a formula that I have in a broader sense. I currently use the formula in a column aspect which works well, however, I don't want to have to repeat the same thing 12 times to achieve my goal. The formula that I am using looks like this. =AND(COUNTIF(D4,""),COUNTA(B4)). This formula covers several cells in the B column. That same formula is used in column D just the B4 and D4 are switched. So for the above formula, I would have to do it 12 times to cover each month, D4,E5,E6 M6,N6.O6 V6,W6,X6, AE6,AF6,AG6 for it to work.
Added, for the switch version, I would have to do it for each month. Is there a better way to do this where it does not have to be entered so many times. Perhaps an array of sorts.
Please see the link below for an example version.. Columns B and D have the condition formatting. Thank you
I am looking for an easier way to use a formula that I have in a broader sense. I currently use the formula in a column aspect which works well, however, I don't want to have to repeat the same thing 12 times to achieve my goal. The formula that I am using looks like this. =AND(COUNTIF(D4,""),COUNTA(B4)). This formula covers several cells in the B column. That same formula is used in column D just the B4 and D4 are switched. So for the above formula, I would have to do it 12 times to cover each month, D4,E5,E6 M6,N6.O6 V6,W6,X6, AE6,AF6,AG6 for it to work.
Added, for the switch version, I would have to do it for each month. Is there a better way to do this where it does not have to be entered so many times. Perhaps an array of sorts.
Please see the link below for an example version.. Columns B and D have the condition formatting. Thank you
Dropbox - File Deleted - Simplify your life
www.dropbox.com