Results 1 to 3 of 3

Excel 2007 : Conditional Formatting of a Cell With a Formula

Threaded View

  1. #1
    Registered User
    Join Date
    09-15-2010
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2007
    Posts
    25

    Conditional Formatting of a Cell With a Formula

    I am attempting to apply conditional formatting (Highlight cells rule>Text that contains)to cells in range H2:J536 based on whether or not they contain a formula. The dialog box pops up and tells me I can not do that.

    The cells I am trying to highlight are results of the subtotal function. How do I diferentiate these cells with color? I am trying to avoid selecting each cell individually.

    Some Things I've Tried
    Close the groups then select all the visible cells. This did not work it selected all the hidden cells as well.
    Used the Select feature to select formulas. This tool was too powerful it selected all the cells that had a formula, not the exclusive cells in the range.
    help!!!
    Last edited by mknispel; 03-25-2011 at 02:16 PM.

Thread Information

Users Browsing this Thread

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

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