I have it half figured out by using other great posts on this site!
I keep today's date ( =today() ) in cell A1 but I keep it hidden.
I used conditional formatting on column K:K so that if the date found in cell is >= A1 it would change cell background to red.
My goal is that I would like users to be aware that a document is due, but instead of just turning the cell red I would like whole row to turn red! How could I achieve this???
(Also as a side question excel tells me to enter a date as dd/mm/yy but my worksheet only shows the correct date (04-mar-97) if I type in yy/mm/dd??? Will all the users have tihssame problem, what is the problem?)
Thanks ahead of time,
Nathalie
I keep today's date ( =today() ) in cell A1 but I keep it hidden.
I used conditional formatting on column K:K so that if the date found in cell is >= A1 it would change cell background to red.
My goal is that I would like users to be aware that a document is due, but instead of just turning the cell red I would like whole row to turn red! How could I achieve this???
(Also as a side question excel tells me to enter a date as dd/mm/yy but my worksheet only shows the correct date (04-mar-97) if I type in yy/mm/dd??? Will all the users have tihssame problem, what is the problem?)
Thanks ahead of time,
Nathalie