Conditionally Format A Single cell based on 2 columns of data

Hi all,

I have a checklist for the required documents located in a separate tab. It has two columns of checkboxes; Needed, and Received. The idea is when someone needs a document, they check 'Needed' - it highlights the row, and when it is received they check 'Received'. Fairly simple stuff.

What I am looking to do is create a warning icon on our main page that when a document is marked as Needed (and thus the linked cell reads TRUE), but the document has not been received (thus the linked cell for that checkbox reads FALSE) for any of the documents in the column, it will conditionally format the cell bright yellow w/ red text.

I can obviously get the first column to work w/ the following formula.

Please Login or Register  to view this content.

My data goes to Q24, and R24. Q column for Needed, and R column for Received.

Any help would be greatly appreciated!

Thank you so much! This formula also works; however, it only fires on the first item on the list.

I believe the issue is because I am trying to conditionally format a single cell, and not the same amount of rows as exist in the document checklist.

Here - I have attached a sample workbook!

Originally Posted by protonLeah

Well, without a sample workbook, I guess you can try changing the refers to range to Q2:R24.

I tried this and it didn't work; I attached a sample workbook in my previous post.