Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-09-2014, 06:26 AM
meggenm meggenm is offline WEEKDAY Function with Conditional Formatting Windows 7 32bit WEEKDAY Function with Conditional Formatting Office 2007
Novice
WEEKDAY Function with Conditional Formatting
 
Join Date: Jan 2012
Posts: 11
meggenm is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 08-09-2014, 09:42 AM
whatsup whatsup is offline WEEKDAY Function with Conditional Formatting Windows 7 64bit WEEKDAY Function with Conditional Formatting 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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
WEEKDAY Function with Conditional Formatting 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:09 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft