If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Bolean Logic with the Advanced Filter
I would like to use a Bolean formula to identify cells with a red background
when performing filtering using the Advanced Filter. I recorded a macro where I highlighted a cell red just to see what that might look like and the result was; With Selection.Interior .ColorIndex = 3 .Pattern = xlSolid End With That being said, I'm still not sure how the Bolean formula would look. Any help would be appreciated! Brian |
Thread Tools | |
Display Modes | |
|
|