Conditional Formatting based on multiple criteria

's Computer Specifications

I have a spreadsheet that needs to hightlight some dates based on multiple
criteria and I cannot get the Formula in the Conditional Formatting function
to work.

A1 = date
A2 = date
A3 = date (not always present)

I want if =A3="" and A2<Now() show the text in A2 in Red.

I've also tried =A3<Date(2000,1,1),A2<Now()

Anyone have any ideas? TIA rasinc

's Computer Specifications

Set formula for conditional formatting for cell A2 to this:-

=AND(A3="",A2<NOW())

--
Regards,

OssieMac

"rasinc" wrote:

> I have a spreadsheet that needs to hightlight some dates based on multiple
> criteria and I cannot get the Formula in the Conditional Formatting function
> to work.
>
> A1 = date
> A2 = date
> A3 = date (not always present)
>
> I want if =A3="" and A2<Now() show the text in A2 in Red.
>
> I've also tried =A3<Date(2000,1,1),A2<Now()
>
> Anyone have any ideas? TIA rasinc

's Computer Specifications

Perfect thanks. I was missing the AND() function I guess.

"OssieMac" wrote:

> Set formula for conditional formatting for cell A2 to this:-
>
> =AND(A3="",A2<NOW())
>
> --
> Regards,
>
> OssieMac
>
>
> "rasinc" wrote:
>
> > I have a spreadsheet that needs to hightlight some dates based on multiple
> > criteria and I cannot get the Formula in the Conditional Formatting function
> > to work.
> >
> > A1 = date
> > A2 = date
> > A3 = date (not always present)
> >
> > I want if =A3="" and A2<Now() show the text in A2 in Red.
> >
> > I've also tried =A3<Date(2000,1,1),A2<Now()
> >
> > Anyone have any ideas? TIA rasinc

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting with multiple criteria	Dave	Microsoft Excel Misc	1	24th Jul 2009 02:36 PM
Conditional Formatting based on 2 criteria	Still learning@work	Microsoft Excel Worksheet Functions	4	7th Apr 2009 10:16 PM
Conditional Formatting based on multiple criteria	twlove@ontuet.com	Microsoft Excel Discussion	2	3rd Aug 2006 09:37 PM
conditional formatting, multiple criteria	=?Utf-8?B?TGFyYQ==?=	Microsoft Excel Worksheet Functions	1	27th Jun 2006 06:39 PM
conditional formatting, multiple criteria	=?Utf-8?B?TGFyYQ==?=	Microsoft Excel Misc	2	27th Jun 2006 06:11 PM