Change Font Colour If

Hello!

I need some help writing a code that would change the font colour to red in column P if the date in that cell is later than the date in column L of that same row. Any help would be greatly appreciated

Maybe this will work for you:

Sub datecolor()

If Range("P3").Value > Range("L3").Value Then Range("P3").Font.ColorIndex = 3

End Sub

Edit:
You'll have to change the range selections to accommodate your worksheet

Sorry about the edits, I misunderstood and thought you wanted the interior changed, it is proper now.

Why not Conditional Formatting?

Can't you just use conditional formatting?

Select P10:P500
Conditional Formatting > Cell Value > greater than

=$L10

Applies to

=$P$10:$P$500

Format...... Font > Red

Hope this helps

[EDIT]

You beat me to it Roy

As post #7

Caange Applies to to this

=$P:$P

And =$L10
to

=$L1

Hope that helps

[EDIT]

The above works for the whole of Column P