| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formate colour of cells in a range of raw
I have the value 1 in cell (A1) 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). This I get an answer last night but how do I do if I wan´t to do like above in a range of raw 1 to 100? Bela |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formate colour of cells in a range of raw
Select A1:F100 then plunk in the CF formula for Condition1 =$A1=1
Do same for Condition2 =$A1=2 Make sure the cell reference is =$A1 which will replicate the column but increment the row. Gord Dibben MS Excel MVP On Sat, 18 Nov 2006 07:54:01 -0800, Bela wrote: I have the value 1 in cell (A1) 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). This I get an answer last night but how do I do if I wan´t to do like above in a range of raw 1 to 100? Bela |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formate colour of cells in a range of raw
Thank you Gord, it works perfect.
Bela "Gord Dibben" skrev: Select A1:F100 then plunk in the CF formula for Condition1 =$A1=1 Do same for Condition2 =$A1=2 Make sure the cell reference is =$A1 which will replicate the column but increment the row. Gord Dibben MS Excel MVP On Sat, 18 Nov 2006 07:54:01 -0800, Bela wrote: I have the value 1 in cell (A1) 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). This I get an answer last night but how do I do if I wan´t to do like above in a range of raw 1 to 100? Bela |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formate colour of cells in a range of raw
Thanks for the feedback.
Gord On Sat, 18 Nov 2006 11:44:01 -0800, Bela wrote: Thank you Gord, it works perfect. Bela "Gord Dibben" skrev: Select A1:F100 then plunk in the CF formula for Condition1 =$A1=1 Do same for Condition2 =$A1=2 Make sure the cell reference is =$A1 which will replicate the column but increment the row. Gord Dibben MS Excel MVP On Sat, 18 Nov 2006 07:54:01 -0800, Bela wrote: I have the value 1 in cell (A1) 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). This I get an answer last night but how do I do if I wan´t to do like above in a range of raw 1 to 100? Bela Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| Macro to hide blank cells in a range | Excel Discussion (Misc queries) | |||
| Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Linear Mode
