Appreciate if anyone here could help me out on what formula to use for my conditional formatting.
What I want to happen is when all of the criterias on both table matches (ie. Client Name, Job Number, Amount), I want the row in the Outstanding table to be highlighted.
See attached file for the data and the expected results.
Thank you!
hi nickyme. select the range you want to apply to (say from J3:N7)
go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=COUNTIFS($D$4:$D$9,$K4,$E$4:$E$9,$L4,$G$4:$G$9,$N4)
format the color accordingly
Last edited by benishiryo; 09-21-2017 at 08:57 PM. Reason: added attachment
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Amazing, it's actually working now. Thank you so much!
Last edited by MyStix01; 09-22-2017 at 01:15 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks