Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - change size of text as a result of conditional format
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.- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - change size of text as a result of conditional format
Yes.
If you provide more information, we can provide more details. :-) "Emece" wrote: 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.- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - change size of text as a result of conditionalformat
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 On Dec 4, 4:56*pm, Emece wrote: 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.- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - change size of text as a result of conditional format
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Emece" wrote: 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.- |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - change size of text as a result of conditional fo
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. "Luke M" wrote: 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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Emece" wrote: 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.- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional number format in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Conditional formatting - change text colour when enteringsame name more than 3 times | Excel Discussion (Misc queries) | |||
Conditional Format - Excel 2007 | Excel Discussion (Misc queries) | |||
How do I change the page size to 11 x 17 in Excel 2007? | Excel Discussion (Misc queries) | |||
conditional format text size | Excel Worksheet Functions |