Conditional formatting

bala_vb

Senior Member

Location: Hyderabad

Posts: 237

Quote:

Originally Posted by puiuluipui

Hi, i need a formula to highlight call containing 2010 and 2009.
I have cells that containing dates in "dd.mm.yyyy" format.

Can this be done?
Thanks!

make sure that dates exist in non text format and use conditonal formatting

assuming date exist in A1.
=or(year(A1)=2009,year(A1)=2010).

if they are in text format, convert into non text format by =text(A1,"dd/mm/yyyy") and use the above formulae.

all the best

__________________
Thanks
Bala

Last edited by bala_vb : May 24th 10 at 06:42 PM Reason: =text formulae syntax updated

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I convert conditional formatting into explicit formatting?	Patrick Harris	Excel Discussion (Misc queries)	0	April 9th 09 12:00 AM
Conditional formatting--different formatting depending on cell con	Tammy S.	Excel Discussion (Misc queries)	3	March 30th 09 08:11 PM
Formatting Conditional Formatting Icon Sets	The Rook[_2_]	Excel Discussion (Misc queries)	3	March 7th 09 08:48 PM
Protect Cell Formatting including Conditional Formatting	Mick Jennings	Excel Discussion (Misc queries)	5	November 13th 07 05:32 PM
Conditional Formatting that will display conditional data	BrainFart	Excel Worksheet Functions	1	September 13th 05 05:45 PM

All times are GMT +1. The time now is 08:50 AM.

Menu

About Us