+ Reply to Thread
Results 1 to 3 of 3

Condition based on Cell Text Color

  1. #1
    Registered User
    Join Date
    09-09-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Condition based on Cell Text Color

    Hi,
    I want to write if statement, If text of the A1 is Red then B1 reflect the Value OK and if A1 is other than Red then NOT OK..
    How retrieve text color value? can get help to write this?

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,076

    Re: Condition based on Cell Text Color

    Use VBA, not possible using formulas
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    09-09-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Condition based on Cell Text Color

    I can u tell me what is code as i don't know VBA. Thanks in advance

+ 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