change font using conditional formatting

M

Milind Keer

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
 
D

Dave Peterson

Check your other post.

Milind said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing font using conditional formatting 1
Outlook 365 overriding formatting choices 0
How does one change the font name with VBA? 0
How to modify and updte specific styles for specific paragraphs across the document 0
Word 2016 - Difficulties Learning Style Creation/Application 0
To find Maximum value using conditional formatting 2
PowerPoint Change font for multiple text boxes 0
Conditional Formatting macro: simple, but doesn't work 6

Top