Related:

- Conditional formatting
- Phone formatting software for pc - Download - File management
- How to clear formatting in excel - Guide
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Conditional formatting 3 color scale percentages ✓ - Excel Forum
- Conditional formatting if two cells match ✓ - Excel Forum

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