+ Reply to Thread
Results 1 to 5 of 5

Conditional format row, copy formula to all rows

  1. #1
    Registered User
    Join Date
    03-24-2018
    Location
    england
    MS-Off Ver
    office 365
    Posts
    20

    Conditional format row, copy formula to all rows

    I would like to run a conditional format which will turn a row RED if cell C3 in the row has "N" in it.

    i can get this working with the "use a formula rule" and entering Formula : =$C$3 = "n" with the applied to as ="$A$3:$C$3"

    I would like to copy this down the sheet changing the cell to check each time to C4, C5, C6 extract with corresponding rows changing when there cell is RED.

    I have tried a number of ways, removing $ sign, copying and pasting special but cannot get it to copy down. It always copies with reference to the first C3 cell

    I have attached a working example with sheet 1 showing one row working and sheet 2 showing what I want to do but I have entered this manually
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Conditional format row, copy formula to all rows

    Select the entire range

    Conditional Formatting
    New Rule
    Use a formula to determine...

    =($C3="n")

    Format as required
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    03-24-2018
    Location
    england
    MS-Off Ver
    office 365
    Posts
    20

    Re: Conditional format row, copy formula to all rows

    I have tried this but then all the rows will turn RED when C3 = n

    What I am trying

    if C3 = n then row 3 turn RED
    if C4 = n then row 4 turn RED
    if C5 = n then row 5 turn RED
    .....etc:

    I could enter this as individual conditions but this will be to much to create

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Conditional format row, copy formula to all rows

    I'm looking at a spreadsheet with that formula and only the rows with column C that have "n" are red

    NOTE the $ in the formula

    Try it again, works ok for me.

    Select the entire range first, the entire range.

  5. #5
    Registered User
    Join Date
    03-24-2018
    Location
    england
    MS-Off Ver
    office 365
    Posts
    20

    Re: Conditional format row, copy formula to all rows

    Ok got it working as you said. i think I still had my old rule running. works a dream thank you

+ 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. Replies: 1
    Last Post: 05-23-2016, 01:53 PM
  2. [SOLVED] Copy Conditional Format based on their respective rows Cell value.
    By gr8spot in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-13-2015, 02:43 AM
  3. Insert Rows and copy format and formula
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2015, 08:00 AM
  4. [SOLVED] Copy conditional formatting with AND formula to multiple rows
    By M_DACH in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-31-2014, 08:59 AM
  5. [SOLVED] Copy Conditional Format only without over writing existing format
    By RobNorwichUK in forum Excel General
    Replies: 2
    Last Post: 01-22-2013, 12:20 PM
  6. easily apply conditional format formula to all rows
    By mania112 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-04-2009, 04:33 AM
  7. conditional format for rows according to the result of a formula
    By plainclothman in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-30-2005, 07:05 PM

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