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

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

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
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
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,079
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
  2. Mobile
  3. Web
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,079
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
  2. Mobile
  3. Web
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,172,017
Messages
5,878,757
Members
433,370
Latest member
mcleven

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