1. ## 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 ???

2. ## 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. ## 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.

4. ## 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. ## 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
•