Forum Discussion

NatalieD1912's avatar
NatalieD1912
Copper Contributor
Dec 10, 2021

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 emai...
Charting
excel
Formulas and Functions
  • NatalieD1912's avatar
    NatalieD1912
    Copper Contributor
    Dec 14, 2021
    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?

    Thanks
    • Juliano-Petrukio's avatar
      Juliano-Petrukio
      Bronze Contributor
      Dec 14, 2021

      NatalieD1912 

      I 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.

       

       

       

       

       

       

Resources