Excel 2007 : Conditional Formatting rows based on a cell

Hi all,

I just wanted to know if it was possible to conditional format and entire row based on 1 of it's cells. e.g. I have a table with 3 columns (total, positive, negative). I want to format the rows of this column based on the overall percentages in the Total Column (i.e. if the total column is greater than 5% of the overall Total then the row should have no fill). So row A has a total at 10, positive 4, negative 6. Row A should then all be filled.

Hope that a) makes sense and b) can be done. If it is posible how do I do it??

Thanks

Select your entire range and then go to the Home tab and click Conditional Formatting from the Styles section.

Select New Rule

Then select Use a Formula to determine which cells to format

Enter formula:

=$A1>0.05*($B1+$C1)

where A1 is your total column in top most row of your selection and B1 and C1 are your positive and negative values in corresponding row.

Note: I assume you actually have a negative in column C.

Click Format and choose colours...

If you selected the "Entire" range as instructed... then followed the steps only replacing $A1, $B1 and $C1 with the references to the top most row in your selection, then it will apply to all rows in your selection (the row values will automatically adjust).

Alternatively, select the range you already apply the formatting to... then select the remaining rows in your database and go to Edit|Paste Special and select Formats.. then click Ok.

Originally Posted by Sashabaz

... Possibly the best and fastest answers on ANY MS help forum....

Not Possibly.. but THE BEST!

Please remember to mark your thread as [Solved] See FAQ in my sig.

Originally Posted by Sashabaz

Awesome!!!! Thanks Again... Possibly the best and fastest answers on ANY MS help forum.... Man... if only everyone was as good as this :P

Old adage..."If everyone were special, then no one would be."