Macro to highlight an entire row if a certain value is in a cell

M

Maggie

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlight a row when certain data is entered 4
Macro needed to highlight a row 10
Conditional Highlight 2
Conditional formatting Entire Row Based on single Cell Value 5
Creating a formula to highlight a row of cells 3
If this cell is highlighted, then also highlight these cells 1
Highlight more than one entire row when cells = TRUE 5
Color row based on cell value 1

Top