problem with conditional foramtting

[SHOOTERTPP]

More than likely my problem is very simple but it seems not for me.

I have two columns, each cell in the two columns will accept a date

I would like to do a conditional format in each row that will highlight the cells if one date is larger than the other.

I've attached a file with a better explanation.

[Mrneski]

Either I have missed something or I think you're over complicating it? Try the below in your contioional formatting

=$A8<$B8

[SHOOTERTPP]

Yes I probably am.

It does work for one row. How would I go about making each row do it individually? I have 1506 rows I would like to apply it to.

Each row using the two cells to apply the conditional formatting.

[Mrneski]

The code above will work on all rows/columns it's applied to
Attachment 665345

[bebo021999]

Try to copy the paste/format to all cells those need formatting.

[SHOOTERTPP]

I got it.

Once again I was trying to over complicate it. Took a breath and realized what I had done.

Thank you very much.........

[Pepe Le Mokko]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.