Hi to all.
I have workbook with 31 sheets,and 60 rows per sheet. In column 2 i have put in the letter "D". What i am after is, if the letter "D" is entered that a macro or vba looks the last 2 sheets for that cell for letter "D". If so color it red. This can only work between rows 11 and 60.
I hope i was clear with the example
Allan