Macro to Change Row Color Based on Two Conditions

[MSmithson]

Hello all,

Just need a little help writing a macro that will make an entire row font bold and color red if two conditions are met:

If the column marked “Excl” and the column marked “Site” (header in row 1) both contain the note “Y” in the same row, then make the entire row bold and font color is red (color index 3).

Help is much appreciated – thanks!


Question also posed at Mr. Excel: http://www.mrexcel.com/forum/showthread.php?t=533437

[DonkeyOte]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.