View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RJBohn3 RJBohn3 is offline
external usenet poster
 
Posts: 5
Default Excel 2007 Conditional Format: Marking Absences

I'm trying to keep absentee spreadsheet. I was hoping to use the green
'check' and red 'x' but I'm unsure how to input the formula so when I mark
the girls Present (P) I get the checkmark or mark Absent (A) I get the x.
Its for a whole list of names and multiple dates