Excel 2007 Conditional Format: Marking Absences

R

RJBohn3

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
 
T

Teethless mama

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.
 
Top