Conditional Formatting

[Still learning@work]

I need help with conditional formatting. I use Excel as a tracking log for
applicant scores. I need a way for Excel to highlight the entire row of if
the applicant testing scores in one of three cells are below passing.

Is there a way to get the whole line to be highlighted if the conditional
format has been met in a specific cell?

 

[Pecoflyer]

I need help with conditional formatting. I use Excel as a tracking lo
for
applicant scores. I need a way for Excel to highlight the entire ro
of if
the applicant testing scores in one of three cells are below passing.

Is there a way to get the whole line to be highlighted if th
conditional
format has been met in a specific cell?

Hi
Select the row to highlight
Go To Conditional formatting
Select "formula is"
Enter your formula making sure that the column value is absolute
F.I. if the condition is that c3>100 enter $c3>100
Then select your formatting
O

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

[ryguy7272]

Take a look at this:
http://www.contextures.com/xlCondFormat01.html
http://www.contextures.com/xlcondformat03.html

This seems ok too:

Regards,
Ryan---