|
|
#1
05-09-2012, 06:39 AM
|
|||
|
|||
Conditional Formatting and formulas
I need to know a formula that will allow me to color cell A1 if J1 is between a date range, i.e. 01/01/11-12/31/11.
I have tried If, IfS, Not, And, and Date. So far, I am not speaking the language required. Thanks 
|
|
#2
05-09-2012, 11:38 AM
|
||||
|
||||
Hi
enter the following as CF Code:
=year(J1)=2011
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Conditional Formatting.
|
Laurie B. | Excel | 6 | 04-09-2012 05:01 PM |
| Conditional Formatting | namedujour | Excel | 3 | 08-25-2011 01:46 PM |
|
help with conditional formatting
|
Snvlsfoal | Excel | 3 | 07-03-2011 11:55 PM |
|
Cell formulas & formatting
|
kungfauxn00b | Word Tables | 3 | 04-05-2011 04:54 AM |
|
Protecting the formatting and formulas in a worksheet
|
furface00 | Excel | 5 | 02-27-2011 02:22 PM |
Windows XP 
Office 2007
Linear Mode
