Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to know Formula for Conditional Formatting Rows, by row # | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Need conditional formatting formula to highlight top ten values i. | Excel Worksheet Functions | |||
Conditional Formatting based on Formula | Excel Worksheet Functions | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) |