Results 1 to 13 of 13

conditional formating on cells based on another cell colour

Threaded View

  1. #1
    Registered User
    Join Date
    12-17-2009
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    34

    conditional formating on cells based on another cell colour

    hi

    i want to do some conditional formating/automation on a table. here are my conditions

    column A has two rows.

    column B - H have two coloumns with two rows each, and a 'check mark' in one of the rows (matching column A's rows)

    I want to be able to put a cell colour in one of the rows in column A, that will automatically fill up the 'check marked' row (with a number or icon) in the second column (B - H).


    difficult to explain but I hope someone can figure what I am asking. I can give a sample of my xlsx if possible on this site.

    what i have is a sports pool going on -

    column A has two teams
    column B has each participants choice with a 'check mark' as the choice indicator.
    Last edited by tubells; 02-27-2011 at 04:15 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