Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Simple question, thanks in advance

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    128
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How do I;

    If the value in A1<8 then A2 cell is red, otherwise A2 is green.

    Thanks a million

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Using Conditional formatting

    Formula is =countif(a1,"<8")Pattern red
    Cell value is greater than 8 Pattern green

    However, with the above the cell will either be red or green all the time.

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    128
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I went into conditional formating but I didn't see how to specify a color

  4. #4
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    for the formula use the "cell value is" in the drop down . To choose colors select the format button in the conditional format window then the font tab and color drop down.
    For background color choose the pattern tab.
    <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Posts
    128
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thank you!!!

  6. #6
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-09 11:40, smittycft99 wrote:
    How do I;

    If the value in A1<8 then A2 cell is red, otherwise A2 is green.

    Thanks a million
    Hi smittycft99 and Brian:

    The CONDITIONAL format should be ...
    condition 1 ... formula is =A1<8 ... Pttern -- color 'red'
    condition 2 ... formula is =A1>=8 ... Pattern -- color 'green

    by the way Brian -- for the conditional formatting here we are not counting any thing so no need for COUNT...

    Hope This Helps!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  7. #7
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yogi,

    Mahalo!



    Brian

Some videos you may like

User Tag List

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
  •