Conditional formating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bbc1 - 16 May 2007 23:14 GMT

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.

Reply to this Message

AKphidelt - 16 May 2007 23:26 GMT

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.

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

Reply to this Message

bbc1 - 16 May 2007 23:51 GMT

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.

> hilight the row that you want formatted... go to Conditional Formatting
>
[quoted text clipped - 9 lines]
> > formatting has strike through applied to font an applied to all cells in that
> > row.

Reply to this Message

David Biddulph - 17 May 2007 10:02 GMT

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.

Signature

David Biddulph

> 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
[quoted text clipped - 24 lines]
>> > in that
>> > row.

Reply to this Message