| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i change cell text colour based on value in other cell
i would like the text in a cell(s) to change colour when the data in another
cell is "0 or blank" and to another colour when the value is actually a number. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i change cell text colour based on value in other cell
Check out the below link regarding conditional formatting based on another
cell. http://www.contextures.com/xlCondFormat02.html If this post helps click Yes --------------- Jacob Skaria "Oscarrot" wrote: i would like the text in a cell(s) to change colour when the data in another cell is "0 or blank" and to another colour when the value is actually a number. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i change cell text colour based on value in other cell
Assuming you want col B to be conditionally formatted based on col A's values
Select col B (with B1 active), apply CF using Formula Is: Cond1: =OR($A1=0,$A1="") Format to taste Cond2: =AND(ISNUMBER($A1),$A1<0) Format to taste Ok out -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Oscarrot" wrote: i would like the text in a cell(s) to change colour when the data in another cell is "0 or blank" and to another colour when the value is actually a number. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditionl format a cell to change text colour | Excel Discussion (Misc queries) | |||
| Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
| change the colour of text in cell for minus figure | Excel Worksheet Functions | |||
| Change colour of Text if number in cell exceed limit | Excel Worksheet Functions | |||
| how do i get cell to change colour when text is added to it to hi. | Excel Discussion (Misc queries) | |||
Linear Mode
