Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to highlight conditional formatting 2

Status
Not open for further replies.
coltaalex

coltaalex

Technical User
Jul 2, 2010
61
US
I have an excel sheet and i want
to highlight or select all the conditional formatting cells
it is possible ?
i want to see what cells contain CF
 
Sort by date Sort by votes
A starting point:
Code: 
For Each fc In Cells.FormatConditions
  fc.AppliesTo.Interior.ColorIndex = 8  ' Cyan
Next

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
PHV ,
why color index =8 ?
i have different colors,
Thank you !!
 
Upvote 0 Downvote
To select cells:
Code: 
ActiveSheet.Cells.SpecialCells(xlCellTypeAllFormatConditions).Select
An error occurs when there is no conditional formatting.
You can select cells without vba with (up to excel 2003 menu) Edit>Goto>>Special.. dialog.

combo
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

K
  • Locked
  • Question
How to resolve define worksheets array
Replies
1
Views
346
combo
combo
Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
220
strongm
strongm
rf92d
  • Locked
  • Question
Hi referring to thread707-107529
Replies
0
Views
230
rf92d
rf92d
rf92d
  • Locked
  • Question
hi referring to thread707-103495
Replies
9
Views
335
Andrzejek
Andrzejek
feipezi
  • Locked
  • Question
How to make a recorded Excel macro (convert a text file to a Workbook) more efficient?
Replies
11
Views
346
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top