| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to highlight an entire row if a certain value is in a cell
I have a worksheet named Data that I would like for a row to be
highlighted when someone enters Paid Off, Missing and Other . How do I do a macro to perform this? I would like each type to be a different color such as Paid off to be highlighted yellow, Missing red,and Other pink. Please help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to highlight an entire row if a certain value is in a cell
You don't need a macro - check your other thread.
Pete On Jan 28, 7:23*pm, Maggie wrote: I have a worksheet named Data that I would like for a row to be highlighted when someone enters Paid Off, Missing and Other . *How do I do a macro to perform this? *I would like each type to be a different color *such as Paid off to be highlighted yellow, Missing red,and Other pink. Please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CF 2007 - Highlight entire row based on one cell | Excel Worksheet Functions | |||
| i want to highlight entire row when selecting a cell in that row | Excel Discussion (Misc queries) | |||
| Highlight the entire row or particular cell using conditional formatting | New Users to Excel | |||
| Can Excel automatically color highlight entire row of cell I'm in | Excel Discussion (Misc queries) | |||
| How do I get excell to highlight entire row when I am in any cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
