I am reviewing data, and I know what responses should be in columns B-D based on the response from column A. Is there a way to highlight responses (based on column A) that break the 'rule' of what I know should be present in B-D?

I assume that this is conditional logic, but I cannot figure it out or find an example. Help!

Please post a sample sheet with some data and manually calculated expected results. Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

See attached! Thank you!

Attached Files

Insurance Audit Test.xlsx (9.5 KB, 8 views)

I suppose you mean "row2 is the template" ( not row 1)?
If so apply the following CF to C3:C5 Do the same for each other column, keeping the =AND($B3="Company " part and adapt the second condition to the new column, like $D3<>$D$2
Be careful with the relative and absolute addressing and adding the trailing space behind "Company "

Can it be done in one go? I don't think so

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post