I need help in IF Formula

[doms123]

Im using Excel2007 and i have an IF Formula having 2 logical test and 3 conditions

A1 is a date for example 04/10/2011

and i want to have an arguement like this

=if(A1=today(),"Due Today", "Waiting to be Validated")

=if(A1 < today(), "Overdue", "Waiting to be Validated")<TODAY(),"OVERDUE", p Validated?< be to ??Waiting ?Overdue?, Validated?)<TODAY(), ?Waiting>

<TODAY(), p Validated?< be to ??Waiting ?Overdue?, Validated?)<TODAY(), ?Waiting Validated?)<TODAY(),?OVERDUE?,>
<TODAY(), p Validated?< be to ??Waiting ?Overdue?, Validated?)<TODAY(), ?Waiting Validated?)<TODAY(),?OVERDUE?,>
I want it to be in Single expression or formula

Please Help me!!!
Thank you in Advance...

 

[Akashwani]

Hi,

Does this work?

=IF(A1=TODAY(),"Due Today",IF(A1"<"TODAY(),"Overdue","Waiting to be Validated"))

Delete the " " here "<"


Ak

 

[Michael M]

Just in case the line..... Delete the " " here "<" confuses you

=IF(A1=TODAY(),"Due Today",IF(A1 < TODAY(),"Overdue","Waiting to be Validated"))

 

[doms123]

Thanks man it works...

Can it be any way that if it is in Overdue it will be filled in red, if it is in due today it will be filled by yellow and if it is in waiting to be validated no fill at all??? I mean the whole row not the cell alone???

 

[Akashwani]

Hi,

You need to add Conditional Formatting.
What is the range of your cells?

Ak

 

[doms123]

T3:t10000

 

[Akashwani]

Hi,

You said that you wanted the whole row and not just the cell, so just to clarify, do you want the cell in column T highlighting if Overdue etc appears in any of those cells or do you want the Row highlighting?

Example....

Excel Workbook
	P	Q	R	S	T	U	V	W
1	*	*	*	*	*	*	*	*
2	*	Dog	Cat	Fish	Due Today	100	300	*
3	*	Dog	Cat	Fish	Overdue	100	300	*
4	*	Dog	Cat	Fish	Waiting to be validated	100	300	*
5	*	*	*	*	*	*	*	*
Sheet5

Please clarify what you require.

Ak

 

[doms123]

that is what i want sir... thank you for the visual.

 

[Akashwani]

Good,

You need to highlight the whole range starting from the top left cell down to the bottom right cell. Im assuming A2:X10000

In 2007 press alt H L N or go to Conditional Formatting - New Rule - Use a formula etc.
In the white box put this....

=$T2="Due Today"

Click Format - Click Yellow, Click Ok, Click New Rule and put this formula in the white box.....

=$T2="Overdue"

Click Format - click Red, click Ok, click Ok

IF your range of cells starts in row 1 change the 2 in the above to 1, like wise if it is row 3 change it to 3, etc etc.

Good luck, I hope it works for you.

Ak

 

[doms123]

Thank you sir... For the help... Thanks a Lot