Related:

- Conditional formatting
- Excel formula to change cell color without conditional formatting - Excel Forum
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Excel conditional formatting if cell contains multiple specific text ✓ - Excel Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- How to clear formatting in excel - Guide

## 3 responses

If B1 is 18 months later then A1, how can the difference be bigger then 18 months???

Can you explain.

Trowa

Can you explain.

Trowa

Hi, basically A1 has a date for example 01/01/08, I want cell B1 to go red 18 months after the date of A1.

Does that make sense?

Does that make sense?

Yes it does.

First we have to determine 18 month after the date in A1, so format cell C1 into date and put the following formula in it: =EOMONTH(A1,18).

Now select B1 and goto conditional formatting, select formula is and input: =B1>C1, select the color red and confirm by hitting OK.

Does this suit your needs?

If not the answer will have to wait till next week, since my weekend starts now.

Best regards

Trowa

First we have to determine 18 month after the date in A1, so format cell C1 into date and put the following formula in it: =EOMONTH(A1,18).

Now select B1 and goto conditional formatting, select formula is and input: =B1>C1, select the color red and confirm by hitting OK.

Does this suit your needs?

If not the answer will have to wait till next week, since my weekend starts now.

Best regards

Trowa