+ Reply to Thread
Results 1 to 3 of 3

copy conditional format, change reference cell

  1. #1
    Registered User
    Join Date
    03-10-2023
    Location
    Prince George, BC
    MS-Off Ver
    365
    Posts
    5

    copy conditional format, change reference cell

    this seems as though it should be easy:

    my conditional format is:
    if value in A1 is less then value in B1, colour it Yellow

    How can do i copy that down for 2, 3, 4????
    anytime i format paint it, the reference cell remains B1

    thanks

  2. #2
    Registered User
    Join Date
    03-10-2023
    Location
    Prince George, BC
    MS-Off Ver
    365
    Posts
    5

    Re: copy conditional format, change reference cell

    Figured it out...
    Conditional format, Cell value less than, formula, colour:
    =($B1:$B30)

    this is assuming 30 rows of course. this would then be format paintable Left/Right but would always reference $B.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,491

    Re: copy conditional format, change reference cell

    Always good to work it out for yourself . Thanks for sharing your solution.

    Just for information, you don't need the brackets.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. [SOLVED] Conditional Format based on a Cell Reference
    By jme1013 in forum Excel General
    Replies: 6
    Last Post: 01-17-2018, 05:14 AM
  2. Conditional format reference own cell?
    By kunkka in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-07-2017, 06:05 PM
  3. [SOLVED] How to copy conditional format with absolute reference?
    By Okoth1 in forum Excel General
    Replies: 3
    Last Post: 11-12-2016, 02:43 AM
  4. [SOLVED] [B]Conditional Format How to Increment a cell reference[/B]
    By Vassellorry in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-10-2016, 07:47 PM
  5. Replies: 3
    Last Post: 02-24-2015, 02:58 AM
  6. [SOLVED] Lock Cell Format - Allow copy and paste of data without format change
    By Chris12InKC in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2006, 12:50 AM
  7. Conditional format from a reference cell?
    By oopsie poopsie in forum Excel General
    Replies: 4
    Last Post: 02-15-2006, 11:30 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