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

then select Formula is and type exactly

=$A$2cell

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

"bbc1" wrote:

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.