+ Reply to Thread
Results 1 to 6 of 6

Conditional format based on another cell column carried down column?

  1. #1
    Registered User
    Join Date
    01-27-2020
    Location
    Florida, US
    MS-Off Ver
    2010 - 365
    Posts
    3

    Conditional format based on another cell column carried down column?

    If i wanted to format a cell based on the formula ( =A1>"" ) in cell C1. How would i carry the conditional format down the entire C Column? Is this achievable in Conditional formatting or will this need to be VBA?

  2. #2
    Forum Contributor
    Join Date
    11-10-2017
    Location
    INDIA
    MS-Off Ver
    365
    Posts
    184

    Re: Conditional format based on another cell column carried down column?

    No dear not all,

    Just follow below steps, after selecting the complete column

    1 Click on Conditional Format Alt H, L, N
    2 Select last value, Use formula to determine cell....
    3 Paste your formula
    4 do formatting as per your wish (change colour/ bg color etc)
    *If you wish you click on *,a way to say ThankYou

  3. #3
    Registered User
    Join Date
    01-27-2020
    Location
    Florida, US
    MS-Off Ver
    2010 - 365
    Posts
    3

    Re: Conditional format based on another cell column carried down column?

    What does the formula need to be if i want ( =A2>"" ) in cell C2, ( =A3>"" ) in cell C3, ( =A4>"" ) in cell C4 & so on. I cant use a table due to previous creator of WB other wise i would use =at symbolA>""

  4. #4
    Registered User
    Join Date
    01-27-2020
    Location
    Florida, US
    MS-Off Ver
    2010 - 365
    Posts
    3

    Re: Conditional format based on another cell column carried down column?

    Sorry ID-10-T Error

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,685

    Re: Conditional format based on another cell column carried down column?

    Be aware that "" is a null text string
    =a1>"" will ALWAYS return false if A contains a number ( XL evaluates the TYPE value before comparing)
    Perhaps you need =A1<>""
    Select your ranger in col C (starting in C1) and use =$A1<>"".
    That's it, the CF will expand automatically

  6. #6
    Forum Contributor
    Join Date
    11-10-2017
    Location
    INDIA
    MS-Off Ver
    365
    Posts
    184

    Re: Conditional format based on another cell column carried down column?

    Hi,

    Thats why we motivate and appreciate to include the sample file, so that if you are unable to write codes at least you have sample file to refer to.

    Check the yellow banner above HOW TO ATTACH YOUR SAMPLE WORKBOOK:

+ 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 - Highlight Month Column Based on Cell value
    By pauldaddyadams in forum Excel General
    Replies: 2
    Last Post: 08-06-2014, 06:36 AM
  2. [SOLVED] Conditional format cells in column, RAG, based on preceding cell value
    By Smudge.Smith in forum Excel General
    Replies: 8
    Last Post: 11-08-2013, 05:21 AM
  3. Conditional Formatting - Format row based on cell value in specific column
    By Kite3 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-08-2013, 12:23 AM
  4. Conditional Format an Entire Column based on percentage of another Column
    By Nolson24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2013, 09:23 AM
  5. [SOLVED] conditional format row based on cell in column A
    By ea223 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-22-2013, 11:36 AM
  6. Replies: 3
    Last Post: 02-21-2011, 11:29 AM
  7. conditional cell format based on cell in same row, previous column
    By tamiluchi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-03-2006, 11:15 AM

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