Excel 2010 conditional formatting: selectively highlighting duplicates
I have dates that are running off a formula in that column based on information it's collecting from other worksheets. I have another column that lists text answers based on a different formula that that column is running.
It is a customer list that runs with names going down page and multiple columns of information for each client running across page
What I want to do is:
paid then turn column
M - same row - a color or border or something.
I will repeat this formula for the various things that
J can say, I just can't figure out how to make conditional formatting read
J to change
To complicate things, in addition to the formula running to collect the date in column
M, there is also a conditional format set up for
M that changes the color of the cells after a certain date. I want to be able to keep that formula, in addition to the one that you are assisting with. I will use highlighting, or something different to avoid any conflicts.