Sunday in Red

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

First column (A2:A31) of this sheet has sequential date
The Start Date is changeable and subsequent dates get updated through a formul

Adjacent column contains these dates in "DDDD" format (Ex: B2=A2
Is there any formula wherein I could show all Sundays in Re

Need Help

Than

Sachin
 
Hi
try the following:
- highligh cells A2:A31
- goto 'Format - Conditional Format'
- enter the formula
=WORKDAY(A2)=1
- choose your format (red color)
 
Hi Sachin,

Select A1:B31
Go to Format>Conditional Formatting
Change Condition 1 to Formula Is
Add formula of =WEEKDAY($A1,1)=1
Click Font
Select the Pattern Tab
Choose Red
Exit

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Sachin said:
First column (A2:A31) of this sheet has sequential dates
The Start Date is changeable and subsequent dates get updated through
a formula
Adjacent column contains these dates in "DDDD" format (Ex: B2=A2)
Is there any formula wherein I could show all Sundays in Red
Click to expand...

Hi Sachin
To start, see David McRitchie's examples here:
http://www.mvps.org/dmcritchie/excel/condfmt.htm#date
Then simply modify the formula to "=WEEKDAY(A2)=1".

Markus
 
mine was intended to highlight the A and B columns as that was how I read
your post.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top