hey

i am using excel 2007 and i have a table of data. I want to apply a condition were two cells in the same row have a condition on them where if the both say yes or both say no they go blue.
I can do this but i want to apply the same rule to 2 cells on different rows.
How do i go about doing this without having to do each individually as there is alot of data and it would take forever
.
Hope someone can help