Conditional formating

[Guest]

I know that I can apply conditional formating to a cell, but I require it to
be applied to a row, ie if a2 is equal to or less than a value then row a2
formatting has strike through applied to font an applied to all cells in that
row.

 

[Guest]

hilight the row that you want formatted... go to Conditional Formatting

then select Formula is and type exactly

=$A$2>cell

Cell of course is your reference... but make sure everything has $ around it
to keep it absolute throughout the row.

 

[Guest]

Thanks that basicly did it, but what I require is cell a4 has a date in it
and the spreadsheet has over 100 rows what I would like is if say a2 to a3
is value 14/5/07 15/5/07 ie
a2 = 14/5/07
a3 = 15/5/07
a4 = 16/5/07
apply conditional format to all rows above a4 with value less than a4 strike
through on font.

 

[David Biddulph]

Have you tried removing the dollar sign from the row reference to make it
relative, rather than absolute?
=$A2>cell
so that the appropriate row number is used when you apply the format to the
other rows.