+ Reply to Thread
Results 1 to 1 of 1

Copying conditional formatting (formula-based) to calculate respective rows

  1. #1
    Registered User
    Join Date
    02-12-2013
    Location
    Connecticut
    MS-Off Ver
    Excel 2010
    Posts
    50

    Copying conditional formatting (formula-based) to calculate respective rows

    Hi,

    This should be a pretty easy answer, but I'm just stuck. I want to use several conditional formatting formulas to format cells (based upon the result). I created the initial set of conditional formulas in cell C2 (see attached spreadsheet) and I want to copy this format to C3 through C11. For each of the cells, I want the conditional formatting to calculate how to format that cell based upon it's respective rows (Row 3 to calculate all the Row 3 parameters, Row 4 to calculate all the Row 4 parameters, etc.). For example, I don't want C10 to calculate whether or not C2 meets the criteria, but what C10 states.

    I tried every combination of relative referencing (C2, $C2, C$2, $C$2) for the initial (and subsequent) cell(s) that is possible and it's still not working out. Please help. I think it's a pretty easy fix, but I'm just stuck.

    Thank you in advance.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formatting rules split up when copying rows
    By finny388 in forum Excel General
    Replies: 1
    Last Post: 02-29-2012, 02:26 PM
  2. Searching Columns and Copying the respective Rows
    By Erenagh in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-10-2011, 11:52 AM
  3. Conditional Formatting two rows and then copying
    By mcsc03 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2008, 04:14 PM
  4. Using conditional formatting to find the respective remarks
    By excelplshelp1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-15-2008, 11:56 AM
  5. [SOLVED] Conditional Formatting Formula to Color Rows Based on Column Value
    By SteveC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2006, 01:25 PM

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