Hi all,
I'm new to this forum and hoping someone can help me. I have a spreadsheet of hospital patient visit data. The A column is a unique identifier for the patient, the B column is the date of their visits, and other columns are additional data related to that particular visit. The data are kept sorted on patient ID number, then on visit date.
Some patients have 2-3 visits, some have dozens.
I know conditional formatting can apply shading to alternating rows by entering the following formula into a new formatting rule:
=MOD(ROW(),2)=0
This doesn't quite work for me, however. Instead, I would like to be able to easily tell when one patient's data ends, and the next begins.
How do I get excel to enter a solid border (the length of the entire spreadsheet) if the data point in column A does not equal the data directly above/below it (i.e., it's a new patient)? Alternatively, how could I tell excel to shade the whole row light gray if the data points in A match, then change to no shading when a new patient appears, then change back to light gray when the next patient appears, and so on?
Any suggestions or links to a tutorial would be very much appreciated!
Bookmarks