+ Reply to Thread
Results 1 to 3 of 3

Conditional format Question

  1. #1
    Forum Contributor
    Join Date
    09-19-2018
    Location
    England
    MS-Off Ver
    O365
    Posts
    263

    Conditional format Question

    Good morning all

    Is there an easy way to fill columns with conditional formats rather than having to do each cell at a time.

    In my table columns L,M / O,P/ Q,R & S,T have different conditional formats in which basically states what is in column H,I fill the cells with colour.

    I have done the top row which works and what I want to do is pull those conditional formats down to fill the rest of the table, however don't want to have to re-write the formula cell by cell which would take forever.

    Is there any easy way to do that?

    Cheers
    Attached Files Attached Files
    Last edited by MattExcelLearner; 11-05-2018 at 05:08 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Conditional format Question

    Chhange $H$3 to $H3 and copy/paste format down as far as you want...
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    09-19-2018
    Location
    England
    MS-Off Ver
    O365
    Posts
    263

    Re: Conditional format Question

    Awesome, many thanks

    Simples - I will remember that for future reference

+ 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 question
    By Kymba in forum Excel General
    Replies: 2
    Last Post: 03-30-2016, 03:11 AM
  2. [SOLVED] Conditional Format Question
    By banker123 in forum Excel General
    Replies: 6
    Last Post: 06-23-2014, 01:30 PM
  3. [SOLVED] Conditional Format Question
    By banker123 in forum Excel General
    Replies: 2
    Last Post: 05-12-2014, 12:26 PM
  4. [SOLVED] Question regarding conditional format question that covers two range criteria
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2013, 12:32 PM
  5. [SOLVED] Conditional format question (I think!)
    By GregSpurs in forum Excel General
    Replies: 12
    Last Post: 04-30-2012, 08:03 AM
  6. Conditional Format Question
    By Wskip49 in forum Excel General
    Replies: 3
    Last Post: 07-31-2011, 12:54 AM
  7. Another Conditional format question
    By Corben in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-28-2006, 12:46 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