Related:
- Conditional formatting
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
- Conditional formatting based on date ✓ - 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
