Everyone,

I'd like to make a group of cells change color based on the result of one cell in the row. So I'd like to make cells A1-AA1 have a red background if the word NO is found in column G1, or turn yellow if the word YES is found there. I'd need to do this individually for about 150 rows. Some will be Yes and some will be NO (and some will be blank until they are reviewed for the Yes/No decision, so no formmatting in some cases)

Can you do this with conditional formatting, or do I need a bit of VBA code? If VBA code, do I have to save the file as XLSM to apply it? I've only found a few ways to do this with code, but I was hoping someone could suggest an easier way.

Thanks!

Vaslo