software

Hello everyone,

Hopefully you can help me with what I am sure is probably easy, but not
to me.

I have data that goes from row 4 to row 295. I want to take the data in
each cell C through H and compare it to the data in column K and L. If
the data in each each cell C through H isn't between the values in K
and L I want to mark the cell yellow.

I have been going though each row and using the not between conditional
formatting function, but I think I could insert an AND formula to
acheive this on all rows at once.

Any help anyone could provide would be greatly appreciated!!

Thanks!--
jgp_2
------------------------------------------------------------------------
jgp_2's Profile: www.excelforum.com/member.php...oamp;userid=27624
View this thread: www.excelforum.com/showthread...hreadid=508148conditional formatting formla is
=AND((C1 gt; $K1),(C1 lt; $L1))

Highlight cells c4 through h295 prior to going into conditional formatting.
You may or may not want to change gt; to gt;= and lt; to lt;=.

--
Kevin Vaughnquot;jgp_2quot; wrote:

gt;
gt; Hello everyone,
gt;
gt; Hopefully you can help me with what I am sure is probably easy, but not
gt; to me.
gt;
gt; I have data that goes from row 4 to row 295. I want to take the data in
gt; each cell C through H and compare it to the data in column K and L. If
gt; the data in each each cell C through H isn't between the values in K
gt; and L I want to mark the cell yellow.
gt;
gt; I have been going though each row and using the not between conditional
gt; formatting function, but I think I could insert an AND formula to
gt; acheive this on all rows at once.
gt;
gt; Any help anyone could provide would be greatly appreciated!!
gt;
gt; Thanks!
gt;
gt;
gt; --
gt; jgp_2
gt; ------------------------------------------------------------------------
gt; jgp_2's Profile: www.excelforum.com/member.php...oamp;userid=27624
gt; View this thread: www.excelforum.com/showthread...hreadid=508148
gt;
gt;