Double condition formula formatting

[TORPIDO]

Hi all,

im trying to autoformat a columns based on three conditions using a formula;

what I want is if:

Column "A" is ="Pending" and column "C" is =>today() and column "D"="Post dated" then format Column "B"

tried using below but didn't work

=AND(TODAY()=>C2,D2="Post dated",A2="PENDING")

will appreciate the help

 

[footoo]

=(A1="Pending")*(C1=>TODAY))=1

 

[TORPIDO]

=(A1="Pending")*(C1=>TODAY))=1

thanks for the revert, not sure if you saw my edit; its actual three conditions

Column "A" is ="Pending" and column "C" is =>today() and column "D"="Post dated" then format Column "B"

 

[alz]

Try this!
=AND($A1="Pending",$C1=TODAY(),$D1="Post dated")

 

[footoo]

thanks for the revert, not sure if you saw my edit; its actual three conditions

=(A1="Pending")*(C1=>TODAY)*(D1="Post dated"))=1

 

[TORPIDO]

=(A1="Pending")*(C1=>TODAY)*(D1="Post dated"))=1

getting formula error in conditional formatting setup window

 

[TORPIDO]

Try this!
=AND($A1="Pending",$C1=TODAY(),$D1="Post dated")

it worked but I want C to be =>

 

[alz]

When you applied the range start from Row No.1 . A1 or B1 Or C1 etc

=AND($A1="Pending",$C1=>TODAY(),$D1="Post dated")

 

[footoo]

getting formula error in conditional formatting setup window

=(A1="Pending")*(C1>=TODAY())*(D1="Post dated")=1

 

[TORPIDO]

When you applied the range start from Row No.1 . A1 or B1 Or C1 etc

=AND($A1="Pending",$C1=>TODAY(),$D1="Post dated")

still not getting formula error, only when I remove > from "C" it works