Results 1 to 4 of 4

Auto filling Conditional Formatting

Threaded View

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    Belfast, NI
    MS-Off Ver
    2010 and 2016
    Posts
    13

    Angry Auto filling Conditional Formatting

    Hi all,

    I'm tearing my hair out at something which is probably quite simple.

    I have a really basic table with barely any automation in it. (Attached to Post)

    Here's the problem.

    I have created a couple of conditional formatting rules on the first row that fill the whole row of the table based on whether there a number in one cell or another. (Fill the whole row green if cell E3 has a number in it, or fill the whole row red if Cell F3 has a number in it).

    I want to apply this to each row of the sheet but when I auto fill it down, the conditional formats fill but the reference cells stay as E3 and F3. This is causing the entire table to be filled instead of just the individual rows.

    I don't want to have to put in conditional formatting rules manually for each row. Is there a way to auto fill down with the reference cells changing to suit each row like a normal formula would?
    Attached Files Attached Files

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