+ Reply to Thread
Results 1 to 3 of 3

Use FindFormat on a Range

Hybrid View

stuartgb100 Use FindFormat on a Range 04-30-2015, 01:28 PM
shg Re: Use FindFormat on a Range 04-30-2015, 01:51 PM
6StringJazzer Re: Use FindFormat on a Range 04-30-2015, 02:01 PM
  1. #1
    Forum Contributor
    Join Date
    04-23-2015
    Location
    UK
    MS-Off Ver
    Office Pro Plus 2021
    Posts
    120

    Use FindFormat on a Range

    For the range K5:K499

    can I use FindFormat to see if any cell has a fill colour other than clear, please ?

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Use FindFormat on a Range

    You can't, from the UI. It would be like finding all words that aren't "Bob".

    You could autofilter and then filter by color.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,987

    Re: Use FindFormat on a Range

    FindFormat sets the Format option for the Find command. You can set what format to look for, but not what not to look for--that is, you can look for a specific fill color, but you can't look for "anything but clear".

    There are ways to do this other than FindFormat. How do you want to use this?
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] FindFormat Accounting Error
    By yusunghee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2013, 12:02 PM
  2. send to range, popup box to input what the range should be each time/select range
    By lax2734 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2012, 01:37 AM
  3. Looping FindFormat with relative cell update
    By adamspain in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-23-2009, 09:29 AM
  4. [SOLVED] FindFormat with Borders not Working
    By xenovah@gmail.com in forum Excel General
    Replies: 0
    Last Post: 06-06-2006, 12:10 PM
  5. FindFormat w/ multiple spreadsheets
    By BarryQ in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-28-2005, 03:13 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1