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

Make the condition for the "N" the 1st condition and the other formatting
the 2nd condition.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"tralbert" wrote in message
...
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

Ok, I'm confused. The "N" is the only condition. If there is an "N" in column
I, then I want the row that "N" is in to be shaded. I can repeat the
formatting for each column if need be.

Thanks!
--
Teri Albert


"Sandy Mann" wrote:

Make the condition for the "N" the 1st condition and the other formatting
the 2nd condition.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"tralbert" wrote in message
...
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

One way:

Select all rows (or just the rows of interest), with a cell in Row 1 the
active cell. Set the dropdowns and inputbox to read

CF1: Formula is =OR($I1="N",$O1="N",$U1="N")
Format1: <patterns/<gray



In article ,
tralbert wrote:

Ok, I'm confused. The "N" is the only condition. If there is an "N" in column
I, then I want the row that "N" is in to be shaded. I can repeat the
formatting for each column if need be.

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