| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro to color the cells according to the values existing in a c
Hi,
Does anyone know if it is possible to do a macro that would automatically color the rows RED( for example ) according to the values in a column ? E.g. at col B, when the value is IN , the entire row would be colored blue. when the value is OUT , the entire row would be colored red. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A macro to color the cells according to the values existing in a c
Use conditional formatting
See http://www.contextures.com/xlCondFormat01.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Zancouth" wrote in message ... Hi, Does anyone know if it is possible to do a macro that would automatically color the rows RED( for example ) according to the values in a column ? E.g. at col B, when the value is IN , the entire row would be colored blue. when the value is OUT , the entire row would be colored red. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A macro to color the cells according to the values existing in a c
hi,
yes it is possible but based on your post, conditional formating might be a better option. in column B put the following 2 coditions condition1...if cell value is = "in" set format to blue condition2...if cell value is = "out" set format to red. in all the other cell in the rows put the following 2 conditions condition1...formula is =IF($B2="in",1,0) set format to blue condition2...formula is =IF($B2="out",1,0) set format to red. hope this helps regards FSt1 "Zancouth" wrote: Hi, Does anyone know if it is possible to do a macro that would automatically color the rows RED( for example ) according to the values in a column ? E.g. at col B, when the value is IN , the entire row would be colored blue. when the value is OUT , the entire row would be colored red. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Backgroud color for 1 cell based on a range of cells values | Excel Discussion (Misc queries) | |||
| How do I sum up values only in cells that are color filled? | Excel Worksheet Functions | |||
| How do I add values fr/ cells with a given fill color (rose)? | Excel Discussion (Misc queries) | |||
| Q: How to color a cell based on values in two cells | Excel Programming | |||
| How do I sum color filled cells in Excel with no values or text? | Excel Discussion (Misc queries) | |||
Hybrid Mode
