Conditional formatting

  • Thread starter Thread starter J Alcorn
  • Start date Start date
J

J Alcorn

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 CF>Formula is: =$D1<your value


Gord Dibben MS Excel MVP
 
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
 
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
 
Back
Top