Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Conditional Formatting (XP)

    I have this preadsheet for tax purposes. When I have to pay tax the conditional formatting says "when cell value is greater then A1 formatting is in red. When cell value is less then A1 formatting is in green.
    But when the amount of tax to pay is less then the amount of tax paid is still comes up in red but it should be a refund.
    I know this sounds complicated so I have attached an example.
    Can you also use IF statements when you use conditional formatting ???
    Thanks for your help

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

    Re: Conditional Formatting (XP)

    Cell B29 contains the amount to pay or the refund. Its formula is =B22-B27. The conditional formatting for this cell says:
    If the cell value is less than that of E27, make the text red.
    If the cell value is greater than that of B27, make the text green.
    This doesn't seem very logical to me. I would say that you need to compare the cell value to 0, not to B27 or E27.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (XP)

    Can you explain how I do that ??? When the amounts are large, the problem doesn't occur, only with small amounts but it looks odd. The cell below tells you whether it is a refund or a payment.
    Needless to say this page usually have all linked cells.. from the rest of the workbook

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

    Re: Conditional Formatting (XP)

    I don't know what is what in your spreadsheet - it is devoid of any explanation, so the following is guesswork.
    I think the first condition for cell B29 should be: if the cell value is less than 0, make the text color green
    The second condition should be: if the cell value is greater than 0, make the text color red.

  5. #5
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (XP)

    That worked. Thanks. I suppose I wanted to do it too complicated...

Posting Permissions

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