changing font using conditional formatting
hi all
how can i change font using conditional formatting?? in fron my data i want to populate "!" (Font - Arial) or "ü" (Font -tick mark in Wingdings) based on condition... If I set font as Arial to that cell it always displays "ü" and not tick mark.. I have to manually go and change the font to Wingdings to make tick mark visible. Any idea how can I handle this using conditional formatting?? or do i need to do a coding if yes!! how?? -Milind |
changing font using conditional formatting
You can't change the font using Format|conditional Formatting (at least not in
xl2003). It may make your life much easier if you used two cells. Milind Keer wrote: hi all how can i change font using conditional formatting?? in fron my data i want to populate "!" (Font - Arial) or "ü" (Font -tick mark in Wingdings) based on condition... If I set font as Arial to that cell it always displays "ü" and not tick mark.. I have to manually go and change the font to Wingdings to make tick mark visible. Any idea how can I handle this using conditional formatting?? or do i need to do a coding if yes!! how?? -Milind -- Dave Peterson |
All times are GMT +1. The time now is 05:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com