+ Reply to Thread
Results 1 to 2 of 2

Change of Cell color

  1. #1
    Registered User
    Join Date
    02-02-2010
    Location
    West Bengsl,India
    MS-Off Ver
    Excel 2007
    Posts
    6

    Change of Cell color

    I want to change the color of a cell if the value of the cell do not satisfy a condition,e.g.
    if(A4-A5)>A2 then the color of cell 6 will change to red.

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Change of Cell color

    In Excel, there is no such thing as a "cell 6". Did you mean cell A6?

    Also, "if(A4-A5)>A2" is not a valid formula. I assume that you meant if A4-A5>A2, then change the fill color of A6 to red.

    If that is what you are looking for, select A6 > Conditional Formatting > New Rule > Use a formula

    =A4-A5>A2

    Format: Fill red > OK > OK

+ 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: 0
    Last Post: 09-26-2012, 01:08 PM
  6. Replies: 5
    Last Post: 05-10-2012, 10:49 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