If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional formatting multiple cells from one cell to another
Hi there, I am looking for a conditional formatting formula so that if C2 or
C4 or C6 or C8 or C12 = $AK$2 to format cell C4 blue AND if C3 or C5 or C7 or C9 or C11 or C13 = $AK$2 format cell C4 green. Can anyone help me out on this one? I tried entering it in that way and it didn't work. |
#2
|
|||
|
|||
Conditional formatting multiple cells from one cell to another
Hi,
Condition 1 will be =OR(C2,C4,C6,C8,C12)=$AK$2 and choose the font format as Blue Condition 2 will be =OR(C3,C5,C7,C9,C11,C13)=$AK$2 and choose the font format as Green -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Loadmaster" wrote in message ... Hi there, I am looking for a conditional formatting formula so that if C2 or C4 or C6 or C8 or C12 = $AK$2 to format cell C4 blue AND if C3 or C5 or C7 or C9 or C11 or C13 = $AK$2 format cell C4 green. Can anyone help me out on this one? I tried entering it in that way and it didn't work. |
#3
|
|||
|
|||
Conditional formatting multiple cells from one cell to another
It didn't work, I just realized that it was cell A4 not C4 that I wanted
formatting and forgot to mention that cell C2:C13 have the months JAN thru DEC. Cell AK2 has the array formula =INDEX(C2:C13,MATCH(1E+100,INDEX(D2:AJ13,0,MAX(IF( D2:AJ13"",COLUMN(D2:AJ13)-COLUMN(D2)+1))))) in it. Does this make a difference in your formula? "Ashish Mathur" wrote: Hi, Condition 1 will be =OR(C2,C4,C6,C8,C12)=$AK$2 and choose the font format as Blue Condition 2 will be =OR(C3,C5,C7,C9,C11,C13)=$AK$2 and choose the font format as Green -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Loadmaster" wrote in message ... Hi there, I am looking for a conditional formatting formula so that if C2 or C4 or C6 or C8 or C12 = $AK$2 to format cell C4 blue AND if C3 or C5 or C7 or C9 or C11 or C13 = $AK$2 format cell C4 green. Can anyone help me out on this one? I tried entering it in that way and it didn't work. |
#4
|
|||
|
|||
Conditional formatting multiple cells from one cell to another
Ashish, is there a formula that will work with array formulas to
conditionally format cell A4 with the array formula =LOOKUP(9.999999999999E+307,INDEX(D2:AH13,0,MAX(IF (D2:AH13"",COLUMN(D2:AH13)-COLUMN(D2)+1)))) in it? "Ashish Mathur" wrote: Hi, Condition 1 will be =OR(C2,C4,C6,C8,C12)=$AK$2 and choose the font format as Blue Condition 2 will be =OR(C3,C5,C7,C9,C11,C13)=$AK$2 and choose the font format as Green -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Loadmaster" wrote in message ... Hi there, I am looking for a conditional formatting formula so that if C2 or C4 or C6 or C8 or C12 = $AK$2 to format cell C4 blue AND if C3 or C5 or C7 or C9 or C11 or C13 = $AK$2 format cell C4 green. Can anyone help me out on this one? I tried entering it in that way and it didn't work. |
Thread Tools | |
Display Modes | |
|
|