I use conditional formatting to highlight cells orange if the data in them is incorrect. I've entered
=IF(OR(AND((AL2)="Yes"),(AM2="")),AL2="",(AND(AL2="No",AM2<>"")))
In other words, if column AL is blank at all, go orange. Also go orange if AL says "No" but there's something in AM, or if AL says "Yes" but there isn't anything in AM.
However, when AL says 'Yes' and AM is blank, it doesn't go orange. What's wrong with my formula?
I've set it to act on range AM2:AM3000 ish.
First, you don't need the IF. Is AM2 really blank or is it "" returned by a formula? Try
=IF(OR(AND((AL2)="Yes"),(ISBLANK(AM2))),ISBLANK(AL2),(AND(AL2="No",AM2<>""))
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
For conditional formatting, Try this........
Hope this helps.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
With an extra parenthesis ) Chemical :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks