Changing cell attributes (such as color) if the cell today's date.

[jbarringer]

I'm trying to make a worksheet I have more effective by having all dates in a column that equal today change their background color. Has anyone ever done this before?

[anilsolipuram]

select the cells where you want the conditional formatting .

go to format->conditional formatting ,select condition1 as "cell value is" from combo box1 , "equal to" value from combo box2 , and paste "=today" in the text textbox.

click format button below textbox and format with whatever color or border and click ok.