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.

=IF(AND(Documents!$Q2=TRUE,Documents!$R2=FALSE),TRUE,FALSE)
My data goes to Q24, and R24. Q column for Needed, and R column for Received.

Any help would be greatly appreciated!