formatting cells based on comparison

S

sparks

I have 5 date colums.
I was wanting to change the background of cells 2-5 based on if they
are equal to cell 1 value

date1 date2 date3 date4 date5

12/01/05 12/16/05 12/01/05

here since date3 = date1 date3 would have a yellow background.

how do you do Conditional Formatting on something like this?


thank you for any pointers for a noob


Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top