Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find 100% by column and color cells
Sub Tester1()
Dim cell As Range For Each cell In Range("A1:A500") If Application.CountIf( _ cell.Offset(0, 9).Resize(1, 247), _ "100%") 0 Then cell.Resize(1, 10).Interior _ .ColorIndex = 3 Else cell.Resize(1, 10).Interior _ .ColorIndex = xlNone End If Next End Sub worked for me. -- Regards, Tom Ogilvy "Duncan_J" wrote in message ... Ok, here is a tough one... which I could do if a filtered 200+ columns one at a time, and which would be a huge macro. I want to filter each column from J all the way to the end, which is IV... I'm filtering for "100%" When filtered and if 100% is in that column. I want to color the cells of a row A though I with color code 35 Thanks for any ideas. It could be done but it would take about a half day to do it manually. DJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find cells w/background color based on conditional formatting | Excel Worksheet Functions | |||
Find feature - Fill cells with color | Excel Discussion (Misc queries) | |||
find 100% by column and color cells | Excel Programming | |||
Find first and last cells in column that have a certain fill color | Excel Programming | |||
Find first and last cells in column that have a certain fill color | Excel Programming |