Hey Guys...

I have been trying for over an hour this morning to figure out how to do the following:

Conditionally Format a WEEKDAY function as follows:
Underline if the date falls on a weekend and to Return Monday as a 0.
I assume I need to create a New Conditional Formatting rule and use "use a formula to determine which cells to format" but I cannot get the return value correctly...



The data table is attached.

Thanks so very much!
meggen

Attached Files

WEEKDAY Function Data - apply Conditional Formatting.xlsx (8.5 KB, 13 views)