+ Reply to Thread
Results 1 to 8 of 8

cell color to change

  1. #1
    Registered User
    Join Date
    11-03-2011
    Location
    kuwait
    MS-Off Ver
    Excel 2003
    Posts
    8

    cell color to change

    Hi

    I have an excel file in which i have just used the basic formula "=today()-E7", in N7 which gives me the number of days passed from the date in E7.
    I have given conditional formatting to N7 that minimum midpoint maximum , turning the cell to red at maximum point.

    Now, in another cell H7 i will be putting the text " Price Given".

    Once I enter that text "Price Given" into H7, I need the cell N7 to change color to Green.

    How can I get this done ?

    I tried conditional formatting specific text; but it is not working.
    Maybe because there is already one formula there ?
    Please advise !

    Thank You

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: cell color to change

    Did you try in N7 conditional formatting?

    =H7="Price Given"
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    11-03-2011
    Location
    kuwait
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: cell color to change

    yes i did
    but it is not working

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: cell color to change

    Well it unfortunately it works for me in my environment, so how about a sample workbook where it does not work for you!

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  5. #5
    Registered User
    Join Date
    11-03-2011
    Location
    kuwait
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: cell color to change

    Hi
    I have uploaded an excel file "Sample".
    if you see the columns i hope you understand what i am trying to achieve.
    Now I am able to change the color of the cells..i used Find function in the conditional formatting.
    But, some cells remain unchanged.
    For example if you will see N7 - has turned green..but corresponding H7 is blank.
    What I want to achieve is column N to turn green only when column H has the word "Given".

    seems like it is not working.
    Hope you can help me in this.
    Attached Files Attached Files

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: cell color to change

    Try...

    =ISNUMBER(SEARCH("Given",H7))

  7. #7
    Registered User
    Join Date
    11-03-2011
    Location
    kuwait
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: cell color to change

    not working.
    Many cells are changing color.

  8. #8
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: cell color to change

    How about this...
    Attached Files Attached Files

+ 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. Change cell format (cell color+font color) based on color of another cell
    By Dedaluss in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2017, 03:27 AM
  2. Change a Range's cell background color to that of another cell's cond. format color
    By kamelkid2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2014, 12:57 PM
  3. [SOLVED] Change cell color depending on cell color, error in code
    By mushedpotatos in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-25-2014, 04:20 AM
  4. Macro to change cell text color based on darkness of cell fill color
    By cincyshirm61 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2014, 12:11 PM
  5. Replies: 5
    Last Post: 05-10-2012, 10:49 PM
  6. Replies: 3
    Last Post: 07-08-2010, 06:48 PM
  7. Format cell color on change, how to change the color in other columns as well?
    By s80NL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-28-2007, 09:24 PM

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