If I use conditional formatting on a column of cells that contain
percentages, if below a figure the cell changes colour etc. The other
columns contain numbers and text. Can the formatting be set to change the
cell colour of the whole row based on the percentage column's outcome?

Thanks in advacnce
Jason Alcorn

Yes.

Assuming column D is your percentage column.

Select the row or a bunch of rows and in CFFormula is: =$D1<your value


Gord Dibben MS Excel MVP

On Sat, 30 Jan 2010 10:50:01 -0800, J Alcorn
wrote:

If I use conditional formatting on a column of cells that contain
percentages, if below a figure the cell changes colour etc. The other
columns contain numbers and text. Can the formatting be set to change the
cell colour of the whole row based on the percentage column's outcome?

Thanks in advacnce
Jason Alcorn

I have data in A1:K10
I what to colour the data (columns A to K) when the C value is less than 10%
I select all the data and in the Conditional Format dialog the formula to
use is
=$C1<10%
Note the $ to make the reference to the C column absolute

Do not colour the entire row (A to VI in Excel 2003 and before, or A to XFD
in Excel 2007+) but just as far to the right as the last used cell
best wishes


"J Alcorn" wrote in message
...
If I use conditional formatting on a column of cells that contain
percentages, if below a figure the cell changes colour etc. The other
columns contain numbers and text. Can the formatting be set to change the
cell colour of the whole row based on the percentage column's outcome?

Thanks in advacnce
Jason Alcorn

Hi,
Many thanks for the replies. However, I have tried the suggestions and I
think I am doing something wrong.
Could you please walk me through the process.
Thanks
Jason

"Bernard Liengme" wrote:

I have data in A1:K10
I what to colour the data (columns A to K) when the C value is less than 10%
I select all the data and in the Conditional Format dialog the formula to
use is
=$C1<10%
Note the $ to make the reference to the C column absolute

Do not colour the entire row (A to VI in Excel 2003 and before, or A to XFD
in Excel 2007+) but just as far to the right as the last used cell
best wishes


"J Alcorn" wrote in message
...
If I use conditional formatting on a column of cells that contain
percentages, if below a figure the cell changes colour etc. The other
columns contain numbers and text. Can the formatting be set to change the
cell colour of the whole row based on the percentage column's outcome?

Thanks in advacnce
Jason Alcorn

.