Ok, I have a spreadsheet that is 11,000 rows long. I create the conditional
format on cell J2 to shade grey if cell J2 is less than cell AU2. Format
works great, but when I use the format painter to copy it into the rest of
the J column, it bases the value off cell AU2. I need J2 to go off AU2, J3 to
go off AU3, J4 to go off AU4, etc. How can I do this, what is the formula,
and please tell me I don't have to do each row seperately?
Any help would be appreciated ASAP.
Thank you
Bookmarks