[Solved] Highlight row for dates in "Holidays" sheet

taylorr113y93 · Post by **taylorr113y93** » Thu Jul 25, 2024 11:04 am

Hi folks, I am making a spreadsheet to track various financial information. I would like to highlight the rows by date that are holidays, listed on the Holiday sheet. I know that there is a conditional formatting, but I don't know the formula or which cells to apply it. That's it.

edit this topic's initial post · Post by **Villeroy** » Thu Jul 25, 2024 1:26 pm

C.F. Formula Is: ISNUMBER(MATCH($A2;$Holidays.$A$2:$A$50;0))

taylorr113y93 · Post by **taylorr113y93** » Thu Jul 25, 2024 2:00 pm

I'm not getting the desired result. It is highlighting all of the blank cells, AND the cells of the rows of the holidays. I need only the Holiday row dates.

Post by **FJCC** » Thu Jul 25, 2024 2:40 pm

On the left side of the Conditional Formatting dialog, there is a drop down list that you have set to Cell Value Is. Change that to Formula Is.

taylorr113y93 · Post by **taylorr113y93** » Thu Jul 25, 2024 3:45 pm

Perfect, thank-you!

[Solved] Highlight row for dates in "Holidays" sheet

[Solved] Highlight row for dates in "Holidays" sheet

Re: I want to highlight entire rows of which the dates are in the "Holidays" list

Re: Highlight entire rows of which the dates are in the "Holidays" list

Re: Highlight entire rows of which the dates are in the "Holidays" list

Re: Highlight entire rows of which the dates are in the "Holidays" list