I'm having problems using conditional formatting to highlight two adjacent cells. My goal is to highlight the cell in column B where the term "flight checklist" is and also highlight the cell immediatly adjacent to that cell. My cell range is A1:B265. So in the given example of "Standard Checklist" falling in B3 I would like to highlight B3 and A3. I know that I can use conditional formating to highlight cell that contains text and format it to fill in red (or whatever color). But I don't know how to also highlight the cell immediatly to the left of the highlighted cell. Would I create an additional rule with an =IF statement saying if True highlight adjacent cell?
I thought I could use something like =IF(A1:B265="Standard checklist",....
Thanks for your time and help, it is greatly appreciated.
Bookmarks