+ Reply to Thread
Results 1 to 3 of 3

Formulas based on color of the row

  1. #1
    Registered User
    Join Date
    06-11-2012
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Formulas based on color of the row

    Hi,
    Excel MONSTERS, please help!!!
    Is it possible to write such a macros?
    Yellow cell in column E, which goes before a white cell in column E = white cell after yellow(in the next row)in column A - first yellow cell after white cell above in column A.
    Clipboard01.jpg
    Example.xlsx
    Last edited by barclay777; 06-11-2012 at 08:45 AM.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Formulas based on color of the row

    Good day,

    Just to get you started..use conditional formatting to achieve results

  3. #3
    Registered User
    Join Date
    06-11-2012
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Formulas based on color of the row

    Can you explain briefly, please. How can I do it?
    I use conditional formatting to color the rows, but what about formulas?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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