Related:
- Conditional formatting
- Excel conditional formatting if another cell contains specific text - Excel Forum
- How to clear formatting in excel - Guide
- 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
- Excel formula to change cell color without conditional formatting - Excel Forum
- Phone formatting software for pc - Download - File management
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