Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    conditional formatting (XP)

    Happy new year to all the loungers
    Ihave this rather large spreadsheet and some of the cells have been formatted using conditional formatting. Is there a quick way of finding these cells ??
    I have tried highlighting the whole page and clearing the conditional formatting but it doesn't like that. Rather then putting amounts in every single cell, I hope there is a quicker way
    Thanks

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: conditional formatting (XP)

    Edit - goto - special
    check "conditional formats"
    <ok>

    All the cells with cond formatting will be selected.

    If you want to clear all the cond formatting in a range (can contain cells with/woithout cond formatting)
    select the range
    Format - cond formatting...
    <delete>
    check all 3 conditons
    <ok><ok>

    All cond formatting will be removed.

    Also Chip Pearson has some VB Routines which work with conditional formatting. They can be adapted to do other things with cond formatting. His code actually can tell which of the conditions is active.

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: conditional formatting (XP)

    This works for me

    <pre>Sub FindCondFormats()
    Dim c As Range
    Dim x

    On Error Resume Next
    For Each c In Selection
    x = c.FormatConditions.Item(1).Type
    If Not IsEmpty(x) Then
    MsgBox c.Address
    x = Empty
    End If
    Next c

    End Sub</pre>


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •