Hi everyone,
i,m looking for a formula to highlight cells based on on text in another cell, attached is the spreadsheet im working on i want cells A thru G based on the text in column I, only 3 different values "auction block", "service over due", and "service soon". I've tried it thru the conditional formatting but it wants to highlight all cells. so i know i did something wrong, any help greatly appreciated.
Not sure what the exact outcome should be.
My guess something as per attached file...?
If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.
thank you thats all i needed,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks