| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change text format dependant on formula result
can i test a cell to see if it is one of 2 results using an
=If(a1="","Unsold","sold") formula and then colour it RED dependant on result eg result is Sold but I want to automatically colour the text RED but if the result is Unsold leave as black text |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change text format dependant on formula result
Use Conditonal Formatting Select Cell(s) and go to Format|Conditional Formatting and select Cell Value Is from 1st drop down.. enter: ="Sold" Click Format and choose Red from the Font tab. -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116216 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell text and background colour dependant on result | Excel Worksheet Functions | |||
| Excel 2007 - change size of text as a result of conditional format | Excel Discussion (Misc queries) | |||
| Format Result of a Formula Combining Text & Numbers | Excel Discussion (Misc queries) | |||
| can i delete cells dependant on the result from a formula | Excel Discussion (Misc queries) | |||
| Change the font on a text box dependant on another cell value | Excel Discussion (Misc queries) | |||
Linear Mode
