+ Reply to Thread
Results 1 to 2 of 2

Can I format an entire column based on the values in the cells in an adjacent column?

  1. #1
    Registered User
    Join Date
    03-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    12

    Can I format an entire column based on the values in the cells in an adjacent column?

    I have one column filled with with dates column (AC) and I have another column (AD) that needs to be checked off when the dates in AC go past due. If Cell AC3 is past due and Cell AD3 is blank then AD3 should turn blue. Same for AC4 and AD4 and so on and so on (it's a long spreadsheet ).

    Is there a way to do this without me having to set formats for every cell individually? When I try to carry down the formatting it keeps the cell references for the above cell. It doesn't carry the formula down. Not sure if I am making sense.

  2. #2
    Registered User
    Join Date
    08-26-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    58

    Re: Can I format an entire column based on the values in the cells in an adjacent column?

    Hi,

    Format the cell (AD1) with the Formula using conditional formatting

    Please Login or Register  to view this content.
    and copy the format..

    Regards,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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