ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   change font using conditional formatting (https://www.excelbanter.com/excel-programming/435887-change-font-using-conditional-formatting.html)

Milind Keer[_2_]

change 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

Dave Peterson

change font using conditional formatting
 
Check your other post.

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 09:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com