Conditional Formatting and formulas

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional Formatting and formulas

FAQ

Thread Tools

Display Modes

05-09-2012, 11:38 AM

Pecoflyer

Windows 7 64bit Conditional Formatting and formulas

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,920

Pecoflyer has a reputation beyond repute

Hi

enter the following as CF

Code:

=year(J1)=2011

and format as needed

__________________
Using O365 v2503 - 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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:32 AM.