+ Reply to Thread
Results 1 to 2 of 2

count highlighted cells

  1. #1
    Registered User
    Join Date
    02-06-2006
    Posts
    1

    count highlighted cells

    Hi,
    Is there a formula that can help me the number of highlighted cells in a row?

  2. #2
    Biff
    Guest

    Re: count highlighted cells

    Hi!

    http://cpearson.com/excel/colors.htm

    You're better off using the logic behind why the cells are colored to craft
    a formula.

    For example, the cells are colored if the values are less than 10.

    =COUNTIF(A1:J1,"<10")

    Biff

    "PASSWORD37" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Hi,
    > Is there a formula that can help me the number of highlighted cells in
    > a row?
    >
    >
    > --
    > PASSWORD37
    > ------------------------------------------------------------------------
    > PASSWORD37's Profile:
    > http://www.excelforum.com/member.php...o&userid=31245
    > View this thread: http://www.excelforum.com/showthread...hreadid=509199
    >




+ Reply to Thread

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