Results 1 to 4 of 4

Conditional Formatting for Each Cell

Threaded View

  1. #4
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Conditional Formatting for Each Cell

    Just use the same procedure and formulae, but this time highlight your range in column B instead of C

    eg
    Applies to
    =$B$2:$B$7

    P.S.
    If you want to format the whole row, highlight your range in columns A to C

    Cheers
    Last edited by Marcol; 06-28-2010 at 06:54 AM.

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