Conditionally formatting an entire row

[StevenK]

It's been a while since I've worked with Excel spreadsheets and needed to do this trick - and find myself unable to recall how.

What I want to be able to do is colour the contents of an entire row in the spreadsheet based on the value in one of it's columns.
For instance if cell A10 contains the number 2 I want to colour the whole of row 10 as red - that is cells A10, B10, C10, etc.

In my quick reminder of how to use conditional formatting I find myself only able to conditionally set the properties of one cell - rather than the entire row.

What am I doing wrong?
Thanks in advance.
Steve

 

[SkipVought]

Hi,

Select the entire range, but configure your formula in the Conditional Formatting Formula Is: box to reference the COLUMN as absolute and the ROW as relative.

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[combo]

This is true, to format conditionally whole row you need to format eazch cell. To do it in one go, select the row and format (use absolute column reference in formatting: $A10 or $A$10).

combo