Conditional Formatting Question

[tralbert]

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!

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[tralbert]

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

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Slyguy2183]

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.

 

[JE McGimpsey]

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>