Need help with conditional formatting

		Microsoft Office Forums > Microsoft Excel > Excel
Need help with conditional formatting

FAQ

Mark Forums Read

Thread Tools

Display Modes

09-11-2017, 05:10 AM

NBVC

Windows 10 Need help with conditional formatting

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

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

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:13 PM.