day of week

Discussion in 'Strategy Development' started by aus_SPIder, Nov 17, 2006.

  1. 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?
     
  2. Sanjuro

    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?
     
  3. 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
     
  4. thanks :D