Good afternoon, I an enormous number of cells with dates on it.
How can conditionally format them so I can apply different colors
depending on the day of the week.
example of the dates: 07/11/2022
That one is Monday and I want it to show with blue background.
Conditionally Formatting for Monday is easy to do as it is self
explanatory on the worksheet but in MY case, there is no word Monday
on the cell and I want it to be that way, just the date but blue if is Monday.
Also, to be able to color other days of the week. Is this possible on XL?
Sorry for asking too much but please I do not know how to use VBA or Macros
and prefer not to. Thank.s