You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Tips
How-to
News
Videos
Stories
Sometimes there's more than one way to get what you want. Take check marks, for example. In Excel, you have several options:
--Steven Thomas
Comments: (7) Collapse
I'm pleased for this beneficial excellent page; this is a form of subject that sustains me although out the day.We've normally heard been lately wanting near to in your web-site right immediately after
I'm not sure but I don't think that styles can embed a conditional formatting. In Excel 2007 (sadly I stilll work on this version), there is a built-in format called "Check cell". I really would appreciate this style to include a conditional formatting (green for check marks, 0 or ok, red for exes, 1 or ko). Does Excel 2010 allow this? Generally speaking , what do you think about that?
I just use Marlette font in the cell, then use a lowercase "a" and wa-laaa you get a nice check mark. Change font size to make it bigger, bold, red, etc...
Hi ViF! Thanks for your comment and question.
Excel 2010's conditional formatting feature includes Icon Sets that by default can display green check marks, yellow exclamation points, and red exes. You can edit the rule so that there are only two formats (green check marks and red exes).
I think it is very handy and really helps make your data look good and easy to interpret at a glance. The first link in the post goes to an earlier post that explains more about conditional formatting in Excel 2010.
Thanks Danny! Great tip - I did not know that, and I'm glad I do now.
Way to help out the community! :)
ViF - No 2011 doesn't allow you to set conditional formatting when formatting a style - great idea though as I use certain custom conditional formats on a regular basis, setting up a style for a customized conditional format would be a real time saver!
There is a 4th option, which may be the best:
www.excelhero.com/.../excel-dynamic-checkmark.html
Regards,
Daniel Ferry
Excel MVP