| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formate colour of cells
I have the value 1 in cell (A,1) then I wan´t the colour to change to red in
cells (B1:F1) or if I have the value 2 in cell (A1) then colour should change to green in cells (B1:F1) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formate colour of cells
You can use Conditional Formatting for this.
1. Select cells B1 through F1 2. From the Format Menu, choose "Conditional Formatting..." 3. Change "Cell Value Is" to "Formula Is" 4. Enter the formula: =$A$1=1 5. Select your format (red) 6. Click the ADD Button 7. Change "Cell Value Is" to "Formula Is" 8. Enter the formula: =$A$1=2 9. Select your format (green) 10. Click OK HTH, Elkar "Bela" wrote: I have the value 1 in cell (A,1) then I wan´t the colour to change to red in cells (B1:F1) or if I have the value 2 in cell (A1) then colour should change to green in cells (B1:F1) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formate colour of cells
Highlight your range
Conditional Formatting Condition 1: =$A$1=1 (Format as Red) Condition 2: =$A$2=2 (Format as Green) "Bela" wrote: I have the value 1 in cell (A,1) then I wan´t the colour to change to red in cells (B1:F1) or if I have the value 2 in cell (A1) then colour should change to green in cells (B1:F1) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formate colour of cells
Thanks for the help! This help saved my sleep to night.
Bela "Elkar" skrev: You can use Conditional Formatting for this. 1. Select cells B1 through F1 2. From the Format Menu, choose "Conditional Formatting..." 3. Change "Cell Value Is" to "Formula Is" 4. Enter the formula: =$A$1=1 5. Select your format (red) 6. Click the ADD Button 7. Change "Cell Value Is" to "Formula Is" 8. Enter the formula: =$A$1=2 9. Select your format (green) 10. Click OK HTH, Elkar "Bela" wrote: I have the value 1 in cell (A,1) then I wan´t the colour to change to red in cells (B1:F1) or if I have the value 2 in cell (A1) then colour should change to green in cells (B1:F1) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formate colour of cells
Thank you for the answer, it works fine.
Bela "Teethless mama" skrev: Highlight your range Conditional Formatting Condition 1: =$A$1=1 (Format as Red) Condition 2: =$A$2=2 (Format as Green) "Bela" wrote: I have the value 1 in cell (A,1) then I wan´t the colour to change to red in cells (B1:F1) or if I have the value 2 in cell (A1) then colour should change to green in cells (B1:F1) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I do not see the selection colour when I select some cells | Excel Discussion (Misc queries) | |||
| Colour of highlighted cells | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| How can I count cells of a specific colour (pattern)? | Excel Worksheet Functions | |||
| HOW TO FORMATE CELLS TO COUNT CELLS WITH A FILL COLOR? | New Users to Excel | |||
Linear Mode
