If date is today then highlight entire row

If column B row whatever = todays date then I want the row from col B to col O, to fill in green. I know I can do this with conditional formatting but I have data that updates itself which causes this conditional formatting to go funny every day, so I really need some sort of macro to do it.

One question, do you have data's after col O?

If No, try using this code,

Please Login or Register  to view this content.

Yes, I do have data after Col O.

I need to change this line

Please Login or Register  to view this content.

I need it so instead of cell.End(x1ToRight) it goes as far as column O. How do I do this?

Sorry man went to eat lunch.

Just change from this line

Please Login or Register  to view this content.

to this line

Please Login or Register  to view this content.

Assuming that you have fix range from Column B:O. just try.

Thanks! Works great.