I'm trying to write a conditional format that will highlight rows in which column B is < 100, C < 500, and A does not begin with a 9.
I have the <100 and <500 down, but I'm not sure how to prevent row 6 from getting highlighted. In my actual data sets, all items that begin with 9 have a 0 in B and C.
See attached
One formula would be
=AND($B2<100,$C2<500,LEFT($A2,1)<>"9")
Don
Please remember to mark your thread 'Solved' when appropriate.
Thank you!
You're welcome.
Note that you don't need the IF function, since the formula will return True/False as appropriate and that's what CF needs to work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks