+ Reply to Thread
Results 1 to 2 of 2

Copying Conditional Formatting to Adjacent Cells

  1. #1
    Registered User
    Join Date
    06-23-2010
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2007
    Posts
    13

    Copying Conditional Formatting to Adjacent Cells

    I have a list of NBA Players in Column A with a list of Yes, No and Maybe in Column I. Based on what Column I lists, the color and fill changes to Green, Red and Yellow using conditional formatting. How do I copy the colors from Column I to Column A, with column A changing as Column I changes?

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Copying Conditional Formatting to Adjacent Cells

    Are the current conditional formulas in column I formulas? or just checking Cell Values?

    If they are formulas, change them so that there is a $ sign preceding each colum I reference.. e.g. =$I2>0 Then you can copy formats to any column.

    if the conditions are Cell Value Is type conditions, then in Column A use formulas and enter something like =$I2>0 (or whatever the condition needs to be) and repeat for the other colours...

    (Where I2 is top most cell you are applying conditional format to)
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

+ 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