Excel 2007 - change size of text as a result of conditional format

E

Emece

Is it possible to specify a condition (using conditional formatting) and
change size or colour of text as a result?

Thanks in advance

Regards,
Emece.-
 
P

Pete_UK

That is exactly what Conditional Formatting does - set your condition
in the dialogue box (eg Cell Value Is, Equal to, Emece) then click the
Format button and in the Font panel you can choose the size and colour
that you want to apply to this condition. Click OK twice to exit the
dialogue boxes.

Hope this helps.

Pete
 
L

Luke M

Yes, you can change color using the condition format. You can not change the
size of the text. Closest you can get is making the text bold, italics, etc.
You can also choose to do a strikethrough.
 
S

Sean Timmons

Well, you can change font size by using VB code instead. So, if you want
conditional, then no. But if you really want the font size changed, VB is
your way to go.
 

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

Conditional Formatting based in cell color 2
Excel 2007 - A Conditional Formatting ?'s 1
vLookup, color as a value 2
Delete rows with duplicated values 2
Delete rows with duplicated values 4
Conditional Formating 3
Conditional Formatting Excel 2007 2
Replace #N/A with 0 1

Top