Conditional Formatting

  • Thread starter Still learning@work
  • Start date
S

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?
 
P

Pecoflyer

Still said:
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?
Click to expand...
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
 
Top