If you are going to highlight in red, make the text colour white so you can
still read your work.
--
I am running on Excel 2003, unless otherwise stated. Please rate posts so we
know when we have answered your questions. Thanks.


"Mike H" wrote:

Hi,

You don't need a macro. select all the rows where this will apply then
Format|Conditional Format
select Formula is
Enter the formula
=$D2="No"
Pick a colour
OK

Change the 2 to the top row of your range.

Mike

"Dolores" wrote:

Is there a macro or formula that I can use to automatically highlight row
once a comment is inserted. I included a sample below

Name Address contact Status
No

If I put no in the status comment, I would like to have the entire row be
highlighted red.

Is this possible?