Conditional Formatting- Only format cells once data is entered

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Conditional Formatting- Only format cells once data is entered

12-15-2015, 11:26 AM

shg

Windows 7 64bit Conditional Formatting- Only format cells once data is entered

Office 2010 32bit

Advanced Beginner

Join Date: Oct 2015

Posts: 55

=AND(E2<>"", E2<>"Done", E2<TODAY())

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Prevent "non-template2 font and format to be entered on slide	Ochimus	PowerPoint	0	06-27-2015 04:01 PM
How can I count cells based on their fill color that was set by conditional format	trueimage	Excel Programming	1	10-25-2013 12:08 PM
Copy format created by a conditional formatting	spk	Excel	2	04-10-2013 04:41 AM
Conditional Formatting over copied and pasted data	kb3264	Excel	6	07-11-2012 07:12 AM
VBA Code to auto resize cells when text entered	OTPM	Excel Programming	0	09-18-2011 04:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:00 AM.