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