Conditional Formatting Formula

[jgp_2]

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!

[Kevin Vaughn]

conditional formatting formla is
=AND((C1 > $K1),(C1 < $L1))

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

--
Kevin Vaughn


"jgp_2" wrote:

>
> 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: http://www.excelforum.com/member.php...o&userid=27624
> View this thread: http://www.excelforum.com/showthread...hreadid=508148
>
>