Excel 2007 : Conditional format for coloured cells

[magikmel]

Hi

In need of a Conditional Format, or might be code!!

I have applied conditional formats to colour cells when the start and end date are entered and for weekends (see attached)....but ultimantly I would also like the calander cells to colour black if column C indicates 'A' (for approved leave) or red for 'P' (for proposed leave).

Can this be done through conditional formatting?..If not, can someone provide me with a code that I can cut and paste.

Any help would be appreciated
Ta

[ConneXionLost]

Use this formula for condition 2 (Proposed)

=AND($C4="P",D4>=$A4,D4<=$B4)

Use this formula for condition 3 (Approved)

=AND($C4="A",D4>=$A4,D4<=$B4)

Click OK.

Cheers,

[magikmel]

Im not sure what im doing wrong, the fomulas make sence but it doesnt seem to be working for me, Ive triple checked and changed absolutes..No joy.

[magikmel]

Problem solved - I swapped =and for =If, works great thx