Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Conditional format oddity in Excel 2007 | Excel Worksheet Functions | |||
Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Recording Absences | Excel Worksheet Functions | |||
Water marking Excel | Excel Discussion (Misc queries) |