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?

Still learning@work;203080 Wrote:
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?
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 c3100 enter $c3100
Then select your formatting
OK


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=55850

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

This seems ok too:
http://www.youtube.com/watch?v=UmvZ8iYx0Mk

Regards,
Ryan---

--
RyGuy


"Pecoflyer" wrote:


Still learning@work;203080 Wrote:
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?
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 c3100 enter $c3100
Then select your formatting
OK


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=55850