Conditional Formatting based on 2 Criteria.

[Philip1957]

Greetings,

I'm sure that when I get this figured out it will be one of those "duh" moments, but none-the-less here's my question.

I want to apply conditional formatting to ($X3) only if cell ($Y3) is blank and the date in ($X3) is older than today.

I've tried variations of =AND($X3<TODAY(), ISBLANK($Y3)) applied to the X column and I can get the cell to format based on the date criteria but not the condition of Y being blank. I need both conditions to be True for the formatting to be applied.

Thanks in advance,
~ Phil

 

[Philip1957]

Greetings,

I'm sure that when I get this figured out it will be one of those "duh" moments, but none-the-less here's my question.

I want to apply conditional formatting to ($X3) only if cell ($Y3) is blank and the date in ($X3) is older than today.

I've tried variations of =AND($X3<today(), isblank($y3))="" applied="" to="" the="" x="" column="" and="" i="" can="" get="" cell="" format="" based="" on="" date="" criteria="" but="" not="" condition="" of="" y="" being="" blank.="" need="" both="" conditions="" be="" true="" for="" formatting="" applied.

Thanks in advance,
~ Phil

=AND($X3<TODAY(), ISBLANK($Y3))</today(),>

 

[seguin85]

<today(),$y3="")
=AND($X3 **less than symbol** TODAY(),$Y3="")

For some reason the < sign cannot be used here, each time I type it in the formula it hides the rest<today(),$y3="")<today(),$y3="")< html=""></today(),$y3="")<today(),$y3="")<></today(),$y3="")

 

[63falcondude]

Add spaces around your inequality signs when posting here.

=AND(X3 < TODAY(),Y3="")

 

[snjpverma]

Put this in conditional formatting rule box
=AND($X$3<TODAY(),$Y$3="")

 

[snjpverma]

Add spaces around your inequality signs when posting here.

=AND(X3<TODAY(),Y3="")

Is it the same everyday ? I have never seen my formulas getting disappeared after the "less than" symbol.

 

[63falcondude]

Is it the same everyday ? I have never seen my formulas getting disappeared after the "less than" symbol.

Sometimes they get cut off and other times they do not. I am not sure exactly what conditions have to be met in order for it to cut off your formula. However, I do know that it has something to do with the forums' HTML. It mistakes part of the formula as code and cuts it off. Just to be safe, I always add spaces before and after inequality signs when posting on this forum.

 

[snjpverma]

ok, thanks falcon

 

[Joe4]

I am not sure exactly what conditions have to be met in order for it to cut off your formula.

Its the greater than or less than signs. They get confused for HTML code on internet forums such as these, unless HTML is turned off.
See: http://www.mrexcel.com/forum/about-board/680917-formulas-not-appearing-completely-read.html

 

[Philip1957]

Thank you!