asked on Excel - conditional formatting with symbols
I have a sheet with dates in Column P and names in column A.
I want to add a Check mark to the names in cell column A if there is a date in column P
If there is no date in column P then nothing happens to the names in column A.
Example:
column A column P
Sue (check mark) 4/1/17
Mike
Joe (check mark) 3/15/17
I want to add a Check mark to the names in cell column A if there is a date in column P
If there is no date in column P then nothing happens to the names in column A.
Example:
column A column P
Sue (check mark) 4/1/17
Mike
Joe (check mark) 3/15/17
Microsoft ExcelMicrosoft Office
Last Comment
Rgonzo1971
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Is there a way to concatenate the names and the checkmarks??
Not that I know