Conditional Formatting

[sweetfriend9]

HI , I need a formula for conditional formatting in which there will be two conditions to be highlighted :

1. Cell should not be blank
2. Date should be less than the current date

if both of the above conditions are met change the color of the cell .

[AliGW]

If the cell contains a date, then it will not be blank, so why do you need the first condition?

[sweetfriend9]

am not able to attach the file , pls find the screenshot for the same


Capture.JPG

[JeteMc]

Try the following formula as a conditional formatting rule: =AND(H2<>"",H2< TODAY())
Let us know if you have any questions.

[63falcondude]

Is your data a table or a range?

If it is a table, you can select the table column and apply the conditional formatting to that column only (stops at the end of the table).

If you do it this way, you would select the Due Date column by left clicking directly over Due Date once your pointer turns into a down arrow > Conditional Formatting > New Rule > Use a formula

=H2 < TODAY()

Format: Fill color of your choice > OK > OK

[sweetfriend9]

Thanks to all , it worked

[63falcondude]

Glad we could help. If this solved your problem, please mark this thread as SOLVED.

[sweetfriend9]

From where i could do that , pls help with the option for " SOLVED"

[63falcondude]

It looks like the thread has been marked as SOLVED.

FYI: to mark a thread as SOLVED,
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved