Make the date Bold if day is Sunday.

[shyam]

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

 

[fairwinds]

Hi,

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

=WEEKDAY(A1)=1

 

[BJungheim]

Use conditional formatting with the condition:

Is equal to ="Sunday"

and set the format to Bold.

 

[shyam]

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]

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]

Mr. Fairwinds,

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

Tks n rgds
Shyam

 

[shyam]

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]

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]

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]

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