| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use "IF" statments to colour text?
Without using VBA or conditional formatting, what is the syntax an "IF"
formula would take if i say, I wanted the contents of A15 to be shown in green. Any help much appreciated, thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I use "IF" statments to colour text?
Not possible if you are eliminating the use of VB or conditional formatting.
Mike "Ashhy Larry" wrote: Without using VBA or conditional formatting, what is the syntax an "IF" formula would take if i say, I wanted the contents of A15 to be shown in green. Any help much appreciated, thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I use "IF" statments to colour text?
Try conditional formatting.
See http://www.contextures.com/xlCondFormat01.html -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mike H" wrote in message ... Not possible if you are eliminating the use of VB or conditional formatting. Mike "Ashhy Larry" wrote: Without using VBA or conditional formatting, what is the syntax an "IF" formula would take if i say, I wanted the contents of A15 to be shown in green. Any help much appreciated, thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I use "IF" statments to colour text?
oops just noticed that you discounted CF. Why?
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mike H" wrote in message ... Not possible if you are eliminating the use of VB or conditional formatting. Mike "Ashhy Larry" wrote: Without using VBA or conditional formatting, what is the syntax an "IF" formula would take if i say, I wanted the contents of A15 to be shown in green. Any help much appreciated, thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I use "IF" statments to colour text?
Hi,
A custom number format [Green][5]General;General Although as the others have said, why no use of conditional format? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Ashhy Larry" <Ashhy wrote in message ... Without using VBA or conditional formatting, what is the syntax an "IF" formula would take if i say, I wanted the contents of A15 to be shown in green. Any help much appreciated, thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I use "IF" statments to colour text?
I have the same problem. conditional format limits to three different
formats. i need 10. "Andy Pope" wrote: Hi, A custom number format [Green][5]General;General Although as the others have said, why no use of conditional format? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Ashhy Larry" <Ashhy wrote in message ... Without using VBA or conditional formatting, what is the syntax an "IF" formula would take if i say, I wanted the contents of A15 to be shown in green. Any help much appreciated, thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I use "IF" statments to colour text?
You have replies at your other post.
Mats K wrote: I have the same problem. conditional format limits to three different formats. i need 10. "Andy Pope" wrote: Hi, A custom number format [Green][5]General;General Although as the others have said, why no use of conditional format? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Ashhy Larry" <Ashhy wrote in message ... Without using VBA or conditional formatting, what is the syntax an "IF" formula would take if i say, I wanted the contents of A15 to be shown in green. Any help much appreciated, thanks -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I use "IF" statments to colour text?
See http://www.contextures.com/xlCondFormat01.html
Sweet! Thanks. "Bob Phillips" wrote: Try conditional formatting. See http://www.contextures.com/xlCondFormat01.html -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mike H" wrote in message ... Not possible if you are eliminating the use of VB or conditional formatting. Mike "Ashhy Larry" wrote: Without using VBA or conditional formatting, what is the syntax an "IF" formula would take if i say, I wanted the contents of A15 to be shown in green. Any help much appreciated, thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| =IF(D13="PAID","YES","NO") Can I change fonts colour | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Linear Mode
