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

Excel 2007 Conditional Format: Marking Absences
 

create a helper column (in column B)

B1 =IF(A1="P",10,0)
copy down
select your range in column B, click on Conditional Formatting icon Icon
Sets select icon set which have the check mark and the cross mark Font
format select font color same as background color.


"RJBohn3" wrote:

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