| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing the color of cells by formula
I wish to change the colors of cells relative to values in other cells in the
same row. This is to be done automatically by formula. Can this be done? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing the color of cells by formula
You will have to use Conditional formatting (on the Format menu) with
the Formula Is option rather than Cell Contents Is. In XL 2003 and earlier you are limited to 3 conditional formats per cell. Hope this helps. Pete On Aug 24, 12:19 am, "Emerogork" <u36894@uwe wrote: I wish to change the colors of cells relative to values in other cells in the same row. This is to be done automatically by formula. Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing several cells text color | Excel Discussion (Misc queries) | |||
| Changing text color within a formula??? | Excel Discussion (Misc queries) | |||
| color changing of cells | Excel Discussion (Misc queries) | |||
| Shaded cells changing color for no reason | Excel Discussion (Misc queries) | |||
| Changing the Color of a Word in Formula | Excel Worksheet Functions | |||
Linear Mode
