Make the date Bold if day is Sunday.

shyam

Active Member
Joined
Jul 18, 2005
Messages
302
I have a list of dates from 1st to 31st of the month in Column A. In column B, is the day, which is linked to column A correspondingly. Now, if the date in column A happens to be a Sunday, the column B should show Sunday in Bold.

eg.

column A Column B
1.9.06 Friday
2.9.06 Saturday
3.9.06 Sunday
4.9.06 Monday

column A Column B
4.8.06 Friday
5.8.06 Saturday
6.8.06 Sunday
7.8.06 Monday

Is there any formula/conditoning format whereby as and when I enter the date the day in next column if it falls on Sunday becomes Bold.?

Tks n rgds
Shyam
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Hi,

You can use the "Formula is" option in conditional formatting and use the formula:

=WEEKDAY(A1)=1
 

BJungheim

Well-known Member
Joined
Jul 24, 2004
Messages
914
Use conditional formatting with the condition:

Is equal to ="Sunday"

and set the format to Bold.
 

shyam

Active Member
Joined
Jul 18, 2005
Messages
302
Mr. Fairwinds

Your formula is working fine if it is used through conditional formatting with a colour.. but it does not make the cell "Bold" if it is Sunday.

Mr. BJungheim.

I tried your formula with conditional formatting in the following way, but it does not make it bold...

In conditional formatting-
Under Condition 1, selected Cell value is
through drop down list selected Equal to
typed ="Sunday" in the next slot.

Under format, made the font style Bold... and gave OK

Noting happens...
could you please check whether what I had done is ok or not..

Tks n rgds
Shyam
 

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638

ADVERTISEMENT

Mr. Fairwinds

Your formula is working fine if it is used through conditional formatting with a colour.. but it does not make the cell "Bold" if it is Sunday.

If it works with a color, it should also work with bold font. (Unless everything is not bold already).

Please try again.
 

shyam

Active Member
Joined
Jul 18, 2005
Messages
302
Mr. Fairwinds,

I am sorry, I tried again. It is working fine.... my mistake.

Tks n rgds
Shyam
 

shyam

Active Member
Joined
Jul 18, 2005
Messages
302

ADVERTISEMENT

Mr. Fairwinds,

[/quote]If it works with a color, it should also work with bold font. (Unless everything is not bold already).
Your formula is working fine with Bold and colour.. But I would like to colour the entire row or only the row in that table with a colour.

Would appreciate if you could help on that.

Tks n rgds
Shyam
 

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,004
Office Version
  1. 365
  2. 2016
Try this

Highlight from top of sheet down to bottom of data set

Use formula is in conditional format

=$B1="Sunday"

The absolute reference is necessary as you are refering o column B only


HTH


Dave
 

shyam

Active Member
Joined
Jul 18, 2005
Messages
302
Mr. Dave

I didn't get you clearly. The cell in column B is highlighted since I had already given the condition in conditional format =weekday(b3)=1, but the whole row is not getting highlighted as required. Now should I add your formula as condition 2 or just overwrite the earlier one?

Tks n rgds
shyam
 

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,004
Office Version
  1. 365
  2. 2016
Hi Shyam

I would overwrite the first one if you are only interested in highlighting if Sunday is the day. In Conditional Formatting if you just want to highlight a cell that is of a certain value then you would use 'Cell Value Is' then set the ranges, format etc. In your case you want to highlight a row based on the value of one cell. This is why you use 'Formula Is' then reference to your cell and set your format

I had assumed that B1 was you first line but this can be changed to suit your needs.

HTH


Dave
 

Forum statistics

Threads
1,136,651
Messages
5,677,004
Members
419,667
Latest member
MegEri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top