Excel question

This is a discussion on Excel question within the A Brief History of Cprogramming.com forums, part of the Community Boards category; This is really simple probably but i cant figure it out. When formating a cell into a Currency; if the ...

  1. #1
    In your face... ha ha ha Liger86's Avatar
    Join Date
    Dec 2002
    Location
    Motorcity Capital
    Posts
    321

    Excel question

    This is really simple probably but i cant figure it out.

    When formating a cell into a Currency; if the value in that cell is negative it changes to red. How can I make a cell red or any other test color if say the value is "5" or below?

    Thanks
    From Ukraine with love!

    Internationally known widely respected

    - Digitally yourz -

  2. #2
    Yes, my avatar is stolen anonytmouse's Avatar
    Join Date
    Dec 2002
    Posts
    2,544
    Select the cell. On the menu, click Format->Conditional Formatting... Use dialog.

  3. #3
    In your face... ha ha ha Liger86's Avatar
    Join Date
    Dec 2002
    Location
    Motorcity Capital
    Posts
    321
    Thanks, im just a bit intoxicated right now,
    From Ukraine with love!

    Internationally known widely respected

    - Digitally yourz -

  4. #4
    The superhaterodyne twomers's Avatar
    Join Date
    Dec 2005
    Location
    Ireland
    Posts
    2,262
    Doing Excel when intoxicated ... well that's a first! You could always use an if statement ...

    if ( C3<5, VALUE TOO LOW, OK )

    which, I think will write it into another cell, but as anonytmouse said, the conditional formatting is the way to go with what you want.

  5. #5
    &TH of undefined behavior Fordy's Avatar
    Join Date
    Aug 2001
    Posts
    5,789
    Format->Cells->Numbers->Custom->Type:

    #,##0.00;[Red]-#,##0.00

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. another do while question
    By kbpsu in forum C++ Programming
    Replies: 3
    Last Post: 03-23-2009, 01:14 PM
  2. C++ Builder and Excel files
    By mfdemi in forum Windows Programming
    Replies: 3
    Last Post: 09-24-2004, 02:51 AM
  3. Reading Excel Files?
    By Daniel in forum C++ Programming
    Replies: 2
    Last Post: 08-13-2003, 07:03 PM
  4. Question...
    By TechWins in forum A Brief History of Cprogramming.com
    Replies: 16
    Last Post: 07-28-2003, 10:47 PM
  5. opengl DC question
    By SAMSAM in forum Game Programming
    Replies: 6
    Last Post: 02-26-2003, 09:22 PM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21