Forum Discussion
Conditional formatting to highlight specific days
I'm sorry if I've missed a thread of this but I can't seem to see one anywhere.
I'm currently making a calendar that's highlighting activity on each day (eg, I want a highlighted cell if an email goes out so I know not to send any others on that day).
I've produced a calendar for the whole year on one sheet going along the row and dates that we have emails booked in (3) on the first column (A). What I now want is that if for example, I have an email booked on 1st Jan, it will highlight that row and column. I'm sure I've managed to use this before but cannot figure out what formula to put in the conditional formatting box...
I've dropped a screenshot in to show what I mean (excuse the basic state of it).
Help would be very appreciated!!
4 Replies
- Hey! That looks like what I'm after, would you explain the 0, column and 2 so I can tweak it for my table, please?
ThanksI provided an attached example.
Zero means exact match argument for the MATCH() formula.
Column() Explanation:
The MATCH() formula will give you back the position of what you are looking for as per your data.
As you can see in the picture below, your lookup_Value for the MATCH() formula starts in the Column 3.
