Hi i have excel 2007 i work at a medical company and we have patient waiting lists. I need the make the spread sheet so that once the date has expired the whole row of data is highlighted. I have been at this all day and i can't figure it out and getting really frustrated. In the appt date colum i would like it to highlight yellow until a date is entered then the highlight goes away. The once the date has expired i would like the whole row of patient info to be highlighted in red. can somone please help me.


thanks so much !! Test.xlsx