+ Reply to Thread
Results 1 to 3 of 3

Copying conditional format rules

  1. #1
    Registered User
    Join Date
    11-01-2010
    Location
    Dayton Ohio
    MS-Off Ver
    Excel 2007
    Posts
    8

    Smile Copying conditional format rules

    I have spreadsheet with 10000 rows & 11 columns of data.
    I want the text in the cells in the row to be red until a certain cell in that row is filled in then the text will turn black.
    I know how to do the conditional format formula but I don't know if there is a way to propagate the conditional format into the remaining rows without having to retype it in for each cell.
    When I try to just copy the 1st row, all of the rows will change color with the 1st row.
    Attached is a sample of what I am trying to do.

    Thanks for any advice.
    Attached Files Attached Files
    Last edited by bombiro; 11-10-2010 at 03:15 PM.
    bombiro

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Copying conditional format rules

    Go to Conditional Formatting | Manage Rules.

    Select and Edit your rule and change formula to =$J2>0 (remove the $ from before the 2)... then click Ok.

    Now change the applies to range to something like =$B$2:$I$100 or whatever you desire.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    11-01-2010
    Location
    Dayton Ohio
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Copying conditional format rules

    Thank you.
    Works great.
    I knew it was something easy.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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