Apply color code to only 3 columns of filtered range

**hutch@edge.net** · 10-07-2009, 03:36 PM

Me again, Gurus.

The following code filters my sheet to show only values less than 0 in column T, (column 20).

Please Login or Register  to view this content.

Now I want to color code the filtered cells Red, but only in columns 18, 19 and 20, (R, S and T). The following code would color ALL cells in the filtered region, but I don't know how to color only columns R thru T.

Please Login or Register  to view this content.

Thanks in advance for any help you can offer.

**Palmetto** · 10-07-2009, 04:21 PM

Why not just use Conditional formatting?

**hutch@edge.net** · 10-07-2009, 04:28 PM

Thanks for the reply, Palmetto.

Conditional formatting would work for the one column containing the number less than 0, but the contents of the other two columns would vary. They consist of Text and Dates. I don't know what conditions I could apply to those cells.

**Palmetto** · 10-07-2009, 04:40 PM

You would use the same CF formula to apply to all of the cells in the target column using an absolute reference in the formula.

CF formula: =$T2=0

Select all of the cells for which to apply the CF, making sure T2 is the first cell in the selection (assume row1 to be header).

The apply the CF using the formula above.

**JBeaucaire** · 10-07-2009, 04:49 PM

Your programming query is resolved like so:

Please Login or Register  to view this content.

**hutch@edge.net** · 10-08-2009, 11:10 AM

Sorry so slow to respond, guys. I had meetings all morning.

The programming solution is the best fit for my purposes, as this would be just part of a pretty lengthy macro. After testing this morning, the code works perfectly. Thanks, JB! And thanks to BOTH of you for taking the time to respond to my cry for help.

Have a good one!!