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?
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?
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