Colour a whole line on todays date

[djfatboyfats]

I need to colour a whole line when the date i have matches todays date, i can do this with conditional formating but only for one column i want this for the whole line, can this be done

Thanks

DJ

[VBA Noob]

Try any avoid doing the whole row. I would suggest selection Col A to Z then in CF add this formula

=$A1=TODAY()

Change Col A to your column

VBA Noob

[djfatboyfats]

No i cant get this to work i have attached a sample of worksheet so you can see

I want the whole row to turn say Yellow if todays date matches date in column D

And the same for column I but a differant colour say green

I tried what you gave but nothing was happening

Thanks

DJ

[VBA Noob]

Seems to work fine for me

VBA Noob

[djfatboyfats]

Yep go, it now thanks very much

[VBA Noob]

Your welcome

VBA Noob