| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
text stye, value depending
hello all, i would like to know how can i set a text style in a cell ב that would be subjugated a cell value.... for example: if cell "A1" is "payed" then the text in cell "B1" will be "blue", bold, text height 14 if not then then the text in cell "B1" will be "green", plain, tex height 11 a. can it be done? b. can the formula work on the value of the same cell ? (i.e: if cel "a1"is... then the text in cell "a1" will be...) much obliged, ell -- ella ----------------------------------------------------------------------- ellar's Profile: http://www.excelforum.com/member.php...nfo&userid=196 View this thread: http://www.excelforum.com/showthread.php?threadid=48424 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert text depending on font colour | Excel Discussion (Misc queries) | |||
| different values depending on how text file is opened | Excel Discussion (Misc queries) | |||
| CONTIF DEPENDING ON TEXT/NUMBER COLOR | Excel Discussion (Misc queries) | |||
| Display text depending on values of 3 different cells? | Excel Worksheet Functions | |||
| show different text in a text box depending on cell value | Excel Programming | |||
Threaded Mode
