Forum Discussion

dlopez20's avatar
dlopez20
Copper Contributor
Aug 23, 2023
Solved

Conditional Formatting Using an entire Column

Hello,    I have a list of dates on one sheet, for example: 12/2/2023 1/6/2024 1/20/2024 2/19/2024 3/5/2024   and a list of Holidays and other exclusion dates in another sheet: 12/25/2023 ...
excel
mtarler's avatar
mtarler
Silver Contributor
Aug 24, 2023
try =ISNUMBER(XMATCH(A1, holidays))
  • dlopez20's avatar
    dlopez20
    Copper Contributor
    Aug 24, 2023

    mtarler I tried incorporating that, but it did not work

    • mtarler's avatar
      mtarler
      Silver Contributor
      Aug 24, 2023

      dlopez20 not sure why. In the attached I give an example show it works and since I included a fun/handy HOLIDAY TABLE I added another version:

      this holiday table calcs the holiday for each year you enter under YEAR and 'included' the holiday if indicated in row 1:

       

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Aug 24, 2023

    mtarler 

    As a comment, ISNUMBER is not required here.

Resources