View Single Post
 
Old 08-09-2014, 09:42 AM
whatsup whatsup is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

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.
Reply With Quote