Thread: Conditional formatting multiple cells from one cell to another
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Loadmaster Loadmaster is offline
external usenet poster
  
Posts: 82
Default 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.
Reply With QuoteReply With Quote