| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'if then' color changes.......................
I am trying to change the color of the text(numeric value) in a cell if it
meets certain criteria. Example: A1= average of B1:H1 The values in B1:H1 will turn Blue if 5% < than A1 The values in B1:H1 will turn Red if 5% < than A1 A1 B1 C1 D1 E1 F1 G1 H1 441 425 374 478 422 446 456 488 (RED) (BLUE) (BLUE) Any help would be greatly appreciated! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
'if then' color changes.......................
Try it like this ..
Select B1:H1 (B1 active), then apply the CF using Formula Is: Condition 1 =B1$A1*1.05 Format Blue fill Condition 2 =B1<$A1*0.95 Format Red Fill Ok out -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "TWWARD" wrote: I am trying to change the color of the text(numeric value) in a cell if it meets certain criteria. Example: A1= average of B1:H1 The values in B1:H1 will turn Blue if 5% < than A1 The values in B1:H1 will turn Red if 5% < than A1 A1 B1 C1 D1 E1 F1 G1 H1 441 425 374 478 422 446 456 488 (RED) (BLUE) (BLUE) Any help would be greatly appreciated! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
'if then' color changes.......................
oops, typos ..
Format Blue fill .... Format Red Fill "Fill" should read as: "Font" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
'if then' color changes.......................
I will try that, but I didn't mention I am using 2003, not 2007, will that
make a difference? "Max" wrote: oops, typos .. Format Blue fill ... Format Red Fill "Fill" should read as: "Font" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
'if then' color changes.......................
"TWWARD" wrote:
I will try that, but I didn't mention I am using 2003, not 2007, will that make a difference? Steps given are for xl2003, my ver. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Powerpoint / Excel: custom pp RGB color doesn't match identical Excelcustom RGB color | Charts and Charting in Excel | |||
| Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
| Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
| My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
Linear Mode
