Results 1 to 4 of 4

How do I make a cell color turn RED

This is a discussion on How do I make a cell color turn RED within the Excel Questions forums, part of the Question Forums category; How do I make a cell color turn RED if the value does not match the parameter. For example: 1. ...

  1. #1
    New Member
    Join Date
    Nov 2003
    Location
    Northern California
    Posts
    3

    Default How do I make a cell color turn RED

    How do I make a cell color turn RED if the value does not match the parameter. For example:

    1. If cell X is not before date in cell Y, make cell X turn "RED".

    2. If cell A is not within the range W to Z, make cell A turn "RED"

  2. #2
    Board Regular barkley's Avatar
    Join Date
    Mar 2003
    Location
    UK
    Posts
    148

    Default Re: How do I make a cell color turn RED

    Use Conditional Formating - look this up in the Help file, but basically you'll set the conditional formating of cell X to contain the formula
    =IF(X<=Y,1,0) then set the format of the cell to contain your red background colour.

    (Goto FORMAT > CONDITIONAL FORMATTING and set condition 1 to read Formula Is... and insert the above, substituting X and Y)

    Hope that helps
    Barkley
    Jockeys! - Something Must've Spooked 'Em

  3. #3
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,277

    Default Re: How do I make a cell color turn RED

    Quote Originally Posted by Bob Katin
    How do I make a cell color turn RED if the value does not match the parameter. For example:

    1. If cell X is not before date in cell Y, make cell X turn "RED".

    2. If cell A is not within the range W to Z, make cell A turn "RED"
    Use Format/Cells/Conditional Formatting/Cell Value Is

  4. #4
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Crested Butte, CO
    Posts
    27,393

    Default Re: How do I make a cell color turn RED

    Welcome to the Board, Bob!

    Take a look at Format-->Conditional Formatting.

    For the first one, in the cell that houses the date you want formatted, you can use Condition 1-->Cell Value Is-->Greater Than-->The cell with the starting date. Format Patterns as Red.

    For the second one, you can use a SUMIF formula, like =SUMIF(W1:Z1,A1) in a seperate cell.

    Conditional Format Cell A1-->Condition 1-->Cell Value Is-->Not Equal To-->The Cell where the SUMIF is located. Format Patterns as Red.

    Hope that helps,

    Smitty

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com