|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
||||
|
||||
Please post a sample sheet with some data and manually calculated expected results. Thx
__________________
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 |
#3
|
|||
|
|||
Re: Pecoflyer
See attached! Thank you!
|
#4
|
||||
|
||||
I suppose you mean "row2 is the template" ( not row 1)?
If so apply the following CF to C3:C5 Code:
=AND($B3="Company ",$C3<>$C$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
__________________
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 |
Tags |
a determined b-d, conditional logic, find incorrect responses |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using Excel to Audit Data Responses (IF and THEN identify wrong answers) | tdeogburn | Excel Programming | 0 | 01-25-2022 04:33 AM |
Am I using the wrong formula? | Father | Excel | 2 | 05-24-2017 12:27 PM |
Demo gone wrong | RyanNIF | Publisher | 1 | 10-19-2011 05:55 AM |
Identify "Propose New Time" meeting responses in VBA, and how to response with them | frilian | Outlook | 0 | 09-02-2010 07:48 AM |
PLEASE HELP-wrong formatting???? | bruce | Word | 10 | 04-10-2010 03:45 PM |