Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting (XP)

    Can conditional formatiing be based upon the results in a different cell? Seems to me that should be able, but I am having trouble to get it to work.

    For example, A1 will contain an numerical value 1, 3 or 5. Cell B1 will contain text of some sort.

    If A1<3, B1 should print in red; if A1 = 3, B1 should print in green; if A1 >3, B1 should print in blue.

    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Formatting (XP)

    Yes, that is possible.
    Select the cell you want to apply conditional formatting to (B1).
    Format the cell the way you want it to look by default, e.g. red (for if A1 < 3)
    Select Format | Conditional Formatting...
    Select Formula Is in the first dropdown.
    Enter a formula in the box next to it, e.g. <code>=(A1=3)</code>
    Click Format...
    Specify the formatting, then click OK.
    Click Add>>.
    Select Formula Is in the first dropdown.
    Enter a formula in the box next to it, e.g. <code>=(A1>3)</code>
    Click Format...
    Specify the formatting, then click OK.
    Finally, click OK to close the Conditional Formatting dialog.

Posting Permissions

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