Forum Discussion
Conditional Formatting - Need Formula Help
Hi,
I am putting together a report for my supervisor regarding our tenant and vendors insurance requirement compliance status. He wants me to pull the data from the website monthly and highlight all of the non-compliant vendors so that the property managers can clearly see who they need to reach out to.
I know I could do this by using data filters, but I think conditional formatting might be a little quicker if it's possible. I've attached a picture here of what I am working with but without our company specific information.
Is there a rule formula I could use basically saying that if a cell in column C says vendors, and the cell in column D of that same row says Non-Compliant, then all 4 cells in the row will be highlighted when I format that way?
Thank you to anyone who can help!
1 Reply
Select A2:D100 or further down as needed. The active cell in the selection should be in row 2.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=AND($C2="Vendors", $D2="Non-Compliant"
The $ before the column letters $ are essential!
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.
