Conditional Formatting

**bundyanimal** · 05-18-2016, 06:06 AM

Hi,

Just wanting to see if there is a quicker way to use the conditional formatting option for the attached image.

I am using the green - red Colour Scale to identify the price range between different contractors.

Currently, I am alt clicking 4 cells, so that the conditional format can work on the cells I have highlighted (as per image) Once I do it with the top row, I repeat the process until I get to the bottom (i.e. go to conditional format and create new format).

Sometimes, this is for rows that are up to 100 lines and I waste a lot of time doing this.

I have tried using format painter, but doesn't seem to work (or I am not doing it correctly).

Is there a quick and easy way to copy this conditional format down to colour visualise the variance in Row 18 to 34 (with respect to Columns H, J, L and N)

conditional_format.png

**TMS** · 05-18-2016, 06:17 AM

Do it once for the top row and then edit the range to which the condition applies. That is, if it says $H$17:$H$17, change it to $H$17:$H$200, or whatever.

**bundyanimal** · 05-18-2016, 06:54 AM

It doesn't seem to work.

I want the 4 cells from each row to compare values, and then the 4 cells from the row below to compare values, and so on.

Cond1.JPG

**TMS** · 05-18-2016, 07:40 AM

OK, post a workbook, not a picture.

**bundyanimal** · 05-18-2016, 08:51 AM

OK

Thankyou.

Find attached link to excel workbook. (Couldn't see a direct link / attachment for upload on this site).

https://app.box.com/s/xhxjsj8guwkqgt46ed80zz31rwf3s14i

Cheers

**bundyanimal** · 05-18-2016, 08:52 AM

Oh.

I just saw the paperclick attachment as well in the "Go Advanced" view

**TMS** · 05-18-2016, 09:06 AM

I just saw the paperclick attachment as well in the "Go Advanced" view

That doesn't work at the moment. You can use Manage Attachments though.

Many people will only download attachments that have been uploaded to the forum.