day of week

[aus_SPIder]

how do i get excel to highlight and change the font of every monday in a time series?

i have my data in teh following format

Date Open High Low Close

i want to highlight red every monday in the date column

can someone tell me how to do this?

 

[Sanjuro]

I think you would need to create a macro which would loop through the dates and update the background color of that date cell.

Does anyone know if there is any other solution than a macro?

 

[JimmyJam]

Use the Conditional Formatting option under the Format Menu as follows:

Format
Conditional Formating
Cell Value is
equal to
Monday

Change font color using the Format button

Regards,

JJ

 

[aus_SPIder]

thanks