Hi Guys
Last week you helped me with a formula for conditional formatting
I'm looing for a bit more help. in that...
A10 that meets the following condtions
either A2 OR B2 contains the word YES and C2 contains the word NO OR YES
so to recap if either of cells A2 or B2 contains YES and C2 contains NO OR YES then I want to color the cell A10 blue
Help as usual greatly appreciated
Barbara :-)
Try:
=AND(OR(A2="Yes",B2="Yes"),OR(C2="Yes",C2="No"))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Tremedous guys as usual
Many Thanks
:-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks