Hi,

Im trying to create a formula for my spread sheet but it seems to me that microsoft have made it very difficult, or it may be my blonde coming through.

I want to create a formula so when i imput a value in to a cell it changes colour for the whole row for example;


If i imput yes into U2 to signify that the row is complete I want the whole row to change colour. this shouldnt be that hard.

at the moment i have a now function and when i imput yes i am manually changing the date. Is there a way that if i imput a value into U2 it can freeze the date on the row.

the second seems abit harder and maybe impossible on microsoft excel 2010.

Please help me because i cant stand to stare at the sheet anymore.

Thanks
Helen