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

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Hi,

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

=WEEKDAY(A1)=1
 
Upvote 0
Use conditional formatting with the condition:

Is equal to ="Sunday"

and set the format to Bold.
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
Mr. Fairwinds,

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

Tks n rgds
Shyam
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,217,439
Messages
6,136,620
Members
450,022
Latest member
Joel1122331

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
Back
Top