Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-15-2011, 11:52 AM
Laurie B. Laurie B. is offline 3 Conditions Windows XP 3 Conditions Office 2007
Novice
3 Conditions
 
Join Date: Feb 2011
Location: New Jersey
Posts: 7
Laurie B. is on a distinguished road
Default

Catalin
Thank you for such a quick reply.

I was able to get the two Exacts to match but the Isblank condition is not working. I even put them in the order that you had yours, Red, Blue, Green.

It doesn't matter what is in Column A, I just need the condition to be if cells C5 and down are blank or null highlight the row.

Is it because the condition =Exact($A5,$C5) = False already has those rows highlighted in Blue? For example, Column A could have a name in that cell and Column C be blank or Column A and C could have names in each cell but they don't match.

In this case should there need to be different conditions? It is strange that the ISBlank condition is working. The cells appear to be blank. Here's an example. Line 3 should be red because Column C is blank.
Exact084ExactNot_Exact105Not ExactIsBlank104

=ISBLANK($C5) =TRUE applied to =$5:$6389
=EXACT($A5,$C5) applied to =$5:$6389
=EXACT($A5,$C5)=FALSE applied to =$5:$6389
I'll keep plugging along for now. I am sure I'm doing something wrong.
Thanks again for your help.
Laurie B.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to set an equation with three conditions? Jamal NUMAN Word 0 07-09-2011 06:05 AM
3 Conditions Vlookup and If conditions together along with match formulas david_benjamin Excel 2 04-11-2011 11:30 AM
3 Conditions Count with multiple conditions bundy5150 Excel 4 02-22-2011 10:00 AM
3 Conditions Using Conditions to Add Values EclipticalD Excel 1 07-08-2010 09:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:30 AM.


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