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

 

[Scott Huish]

Select all the columns you want to highlight (so if your rows cross from Column A to Column J, select all those columns)

Click on Format, Conditional Format,
Change Cell Value is to Formula Is:
Put this in the formula box:
=WEEKDAY($A1)=1
Click on Format, select your formatting options
Click OK
Click OK

I'm using Column A in the formula because that's the column you said held the dates.

 

[shyam]

Dear Mr. Hotpepper

Thank you for your reply. It is working great...

One more thing, alternatively, in case I want to colour the whole row, i.e. from a1 to iv1, without highlighting the range, then what would be the alternate formula ?

Tks n rgds
Shyam

 

[dave3009]

Hi Shyam

Apply the formula HOTPEPPER gave you to each column. Easiest way is to highlight your range and do Format>Conditional Format>select Formual is enter the formula, set the format
Click OK
ClickOK

KR


Dave

 

[Scott Huish]

Why don't you want to highlight the whole sheet? It can be done with one mouse click by clicking in the square in the left uppermost corner of the sheet between the row headers and the column headers.