Point out wrong responses (A determined B-D, based on A how to highlight wrong response in B-D)
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!
|