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


    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:

    Conditional Formating
    Cell Value is
    equal to

    Change font color using the Format button


  4. thanks :D