Results 1 to 2 of 2

IF formula to color "less than" values in a cell that alread

This is a discussion on IF formula to color "less than" values in a cell that alread within the Excel Questions forums, part of the Question Forums category; How do you enter an IF formula to a cell that has a percentage formula =(E3/F3) in it? I would ...

  1. #1
    New Member
    Join Date
    Nov 2002
    Posts
    2

    Default

    How do you enter an IF formula to a cell that has a percentage formula =(E3/F3) in it? I would like to color any values less than 50% red.

  2. #2
    Board Regular
    Join Date
    May 2002
    Posts
    890

    Default

    Try Conditional Formatting

    Go to Format/Conditional Formatting/Cell value is, choose cell/font color, click OK OK

    [ This Message was edited by: maxflia10 on 2002-11-16 18:09 ]

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