Try IF((Cell)="N",1) and apply that to the row you want highlighted. I
haven't figured out how to copy that formatting to other rows and have it
fill like a regular formula instead of always referencing the original cell.

"tralbert" wrote:

Hey out there helpful Excel folks.

I need a formula to put in the conditional formatting, where if an "N" is
put into a cell in columns I, O or U then the respective row that "N" goes
into will be shaded gray. Mind you, I have conditional formatting set up in
other columns that affect these rows that will need to be overridden.

Thanks for the assistance!
--
Teri Albert