It’s very often the people are looking for checklist
and add the check mark on it. Here is the very simple step to achieve it.
1.
Open the Excel sheet
2.
Create the list where to put the
check mark
3.
Select the column in which the tick
mark to be enter
4.
Go to Conditional Formatting and
select New Rule
5.
Change the Format Style “Icon Sets”
6.
Select the icon “right tick mark”
7.
Change the Type to ‘Number’
8.
Icon is ‘right tick mark’ when value
is >= 1
9.
‘No cell icon’ when value is < 1
10.‘No cell
icon’ when value is < 0
11.Don’t forgot
to check ‘Show icon only’ in Icon Style
12.Now go to
selected column then write 1 and press Enter
13.You will see
the right tick mark over there.
You did it!! Enjoy….
No comments:
Post a Comment