Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-26-2022, 10:30 AM
tdeogburn tdeogburn is offline Point out wrong responses (A determined B-D, based on A how to highlight wrong response in B-D) Windows 10 Point out wrong responses (A determined B-D, based on A how to highlight wrong response in B-D) Office 2016
Novice
Point out wrong responses (A determined B-D, based on A how to highlight wrong response in B-D)
 
Join Date: Jan 2022
Posts: 5
tdeogburn is on a distinguished road
Default 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!
Reply With Quote
  #2  
Old 01-27-2022, 01:47 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Point out wrong responses (A determined B-D, based on A how to highlight wrong response in B-D) Windows 7 64bit Point out wrong responses (A determined B-D, based on A how to highlight wrong response in B-D) Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 01-27-2022, 01:53 PM
tdeogburn tdeogburn is offline Point out wrong responses (A determined B-D, based on A how to highlight wrong response in B-D) Windows 10 Point out wrong responses (A determined B-D, based on A how to highlight wrong response in B-D) Office 2016
Novice
Point out wrong responses (A determined B-D, based on A how to highlight wrong response in B-D)
 
Join Date: Jan 2022
Posts: 5
tdeogburn is on a distinguished road
Default Re: Pecoflyer

Quote:
Originally Posted by Pecoflyer View Post
Please post a sample sheet with some data and manually calculated expected results. Thx
See attached! Thank you!
Attached Files
File Type: xlsx Insurance Audit Test.xlsx (9.5 KB, 6 views)
Reply With Quote
  #4  
Old 01-28-2022, 01:07 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Point out wrong responses (A determined B-D, based on A how to highlight wrong response in B-D) Windows 7 64bit Point out wrong responses (A determined B-D, based on A how to highlight wrong response in B-D) Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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)
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
__________________
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
Reply With Quote
Reply

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
Point out wrong responses (A determined B-D, based on A how to highlight wrong response in B-D) 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
Point out wrong responses (A determined B-D, based on A how to highlight wrong response in B-D) PLEASE HELP-wrong formatting???? bruce Word 10 04-10-2010 03:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:13 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft