Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a cell I'd like to change color every Monday as an alert to a
task is there a way I can do this using conditional formatting? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try this:
Conditional Formatting Formula Is: =WEEKDAY(TODAY(),2)=1 Set the format of your choice Every Monday the format will change to what you set. If today is not Monday, no format is set. Biff "Joe" wrote in message oups.com... I have a cell I'd like to change color every Monday as an alert to a task is there a way I can do this using conditional formatting? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try:
Select your cell and in CF: FormulaIs: =weekday(Today(),2)=1 and set colour "Joe" wrote: I have a cell I'd like to change color every Monday as an alert to a task is there a way I can do this using conditional formatting? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Feb 21, 2:52 pm, Toppers wrote:
Try: Select your cell and in CF: FormulaIs: =weekday(Today(),2)=1 and set colour Thanks to both of you, so am I to assume that if I want to change the day to Wednesday it would be =weekday(Today(),4)=1 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
NO ...=WEEKDAY(Today(),2)=3
the 2 signifies that Monday=1, Sunday=7 Look at WEEKDAY function HELP. "Joe" wrote: On Feb 21, 2:52 pm, Toppers wrote: Try: Select your cell and in CF: FormulaIs: =weekday(Today(),2)=1 and set colour Thanks to both of you, so am I to assume that if I want to change the day to Wednesday it would be =weekday(Today(),4)=1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I change cell color using conditional formatting | Excel Discussion (Misc queries) | |||
change color of text in cell without conditional formatting | Excel Discussion (Misc queries) | |||
Conditional color formatting entries have wild color. | Excel Discussion (Misc queries) | |||
Cell color change without using conditional formatting | Excel Discussion (Misc queries) | |||
configure hyperlink formatting | Excel Discussion (Misc queries) |