| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic colouring of cells
I've set up an IF condition on a column of cells and want to colour a
separate column of cells depending on the result e.g. in column F the formula is IF((E6$D$3+30),"0","1"). So, if cell F4="1", I want cell G4 to turn red. Similarly, if cell F4="0", I want cell G4 to turn green. Sure I've seen it done before but cant work it out. Thanks for any help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatic colouring of cells
formatconditional format
-- Don Guillett SalesAid Software "plf100" wrote in message ... I've set up an IF condition on a column of cells and want to colour a separate column of cells depending on the result e.g. in column F the formula is IF((E6$D$3+30),"0","1"). So, if cell F4="1", I want cell G4 to turn red. Similarly, if cell F4="0", I want cell G4 to turn green. Sure I've seen it done before but cant work it out. Thanks for any help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatic colouring of cells
As easy as that! Thanks Don.
"Don Guillett" wrote: formatconditional format -- Don Guillett SalesAid Software "plf100" wrote in message ... I've set up an IF condition on a column of cells and want to colour a separate column of cells depending on the result e.g. in column F the formula is IF((E6$D$3+30),"0","1"). So, if cell F4="1", I want cell G4 to turn red. Similarly, if cell F4="0", I want cell G4 to turn green. Sure I've seen it done before but cant work it out. Thanks for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
| Automatic Colour of Cells in Excel | Excel Discussion (Misc queries) | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| Automatic copying data excluding blank cells | Excel Worksheet Functions | |||
Linear Mode
