| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format a DIFFERENT cell
I'd like to set something up so if cell F1 meets my requirements (say, 120),
cell A1 turns color. Is this possible (without complicated programming, please)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format a DIFFERENT cell
Select A1 and FormatConditional FormattingFormula is:
=$F$1120 Format to a nice color and OK your way out. Note the $ signs can be removed or changed around to allow copying this to other cells. Gord Dibben MS Excel MVP On Thu, 19 Jun 2008 14:51:14 -0700, ClaireView wrote: I'd like to set something up so if cell F1 meets my requirements (say, 120), cell A1 turns color. Is this possible (without complicated programming, please)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Linear Mode
