Hi,

I'm hainvg trouble creating a formula to highlight a particular column based on a day reference in another cell.

ie. if cell L1=Monday, highlight column E
ie. if cell L1=Tuesday, highlight column F

and so forth

I'm trying to add a condional format formula to all the cells in a column. Columns E through I would all reference cell L1.

Any help would be appreciated.