Results 1 to 5 of 5

Conditional formatting of visible cells Excel 2010

Threaded View

  1. 05-11-2017, 02:04 PM #2
    tim201110
    tim201110 is offline
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Conditional formatting of visible cells Excel 2010

    as a way with user difined function 
    Function strhd(r As Range) As Boolean
strhd = Not Rows(r.Row & ":" & r.Row).EntireRow.Hidden
End Function
    Attached Files Attached Files
    Last edited by tim201110; 05-11-2017 at 02:20 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Mail only visible cells with conditional formatting
    By Protonspounge in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2017, 11:14 AM
  2. Excel 2010 - Pivot Table conditional formatting - use multiple rows formatting on one row
    By ofirmarco in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-08-2016, 03:14 PM
  3. Use conditional formatting only on visible not hidden cells
    By JackBauer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-24-2014, 08:26 AM
  4. Paste to visible cells only (Excel 2010)
    By dihris in forum Excel General
    Replies: 8
    Last Post: 11-15-2013, 03:48 AM
  5. [SOLVED] Excel 2010 - conditional formatting - blank cells
    By Phil81503 in forum Excel General
    Replies: 5
    Last Post: 07-01-2013, 02:56 PM
  6. [SOLVED] Excel 2010 Conditional Formatting to Highlight input cells based on Dates
    By chrisb84 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-20-2013, 09:39 AM
  7. [SOLVED] Conditional Formatting of Cells in Excel 2010
    By LadyScot101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2012, 04:38 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1