Conditional Formating with IF statement?
Condintional formating guruos,
I need to set-up conditional formating for multiple selections please. In other words, if I have a list of options (Peter, John, Hanna,...etc). I need to say if (Peter & Hana) shade row #1 with same color & leave it blank for John. For row # 2, shade it for (John & Hana) with same color.
Please see attached document ready for your formula. Thanks in advance
Need a bit more information but will have to look at this tomorrow. I'm assuming that each item in the dropdown will have a different list of applicable items, so I need a complete list of which items are applicable for each choice in your dropdown list. Can write formula from that. Please advise.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
That is correct...The attached file answer your inquiries
see the attatch file
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Thanks. but this isn't really what I am looking for.
C13 to K20 won't exist in the final report. These cells are for internal referenc only.
End goal is when we select program type from B4, then only applicable fields will pop-up or be unshaded under (Maste list column)-Applicable fields cab be pulled form adjacent columns.
Kindly advise
see the attatch file
in my opinion, to high light a column out of a range is not possible without VBA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks