Need help with conditional formatting

NBVC · #1 09-11-2017, 05:10 AM

Select from A4 to D7 and try these conditional formatting formulas:

=AND($F4<>"Paid",TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),$E4)>=6) for orange

=AND($F4<>"Paid",TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),$E4)>=3) for blue

=AND($F4<>"Paid",TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),$E4)>0) for green

in that order

mikehk · #2 09-17-2017, 08:33 PM

Thanks a lot.
I will try it out and revert back if any issues.

Best regards

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting	bbutl027	Excel	15	12-05-2016 08:56 PM
Conditional Formatting	sdfrance	Excel	3	01-06-2015 07:10 AM
Conditional formatting that ignores other formatting rules	info_guy2	Excel	1	07-03-2014 10:07 AM
Conditional Formatting	jdc15371	Excel	2	06-26-2014 06:34 AM
Conditional Formatting	teza2k06	Excel	3	01-19-2014 02:34 AM