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.