#1
|
|||
|
|||
WEEKDAY Function with Conditional Formatting
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 |
#2
|
|||
|
|||
Hi meggen
You want conditional formating to change the cells' values in case it's a monday? - That's not possible, as it says it can apply a cond. format, but it can't change any value! To underline saturdays and sundays mark the whole range you want to apply the formating, ---> choose from the ribbon "Conditonal Formating" ---> new rule In the dialog choose ---> based on formula and enter the formula: =weekday($A2,3)>4 Klick on format and choose the format you like to be applied. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formatting that ignores other formatting rules | info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Conditional Formatting | jdc15371 | Excel | 2 | 06-26-2014 06:34 AM |
conditional formatting | otuatail | Excel | 1 | 06-06-2012 05:07 AM |
Conditional formatting | zanat0s | Excel | 4 | 01-20-2012 03:30 AM |
My weekday function aint working | FraserKitchell | Excel | 12 | 05-25-2010 04:42 PM |