View Single Post
 
Old 02-10-2013, 01:30 AM
Kevin@Radstock Kevin@Radstock is offline Windows 7 32bit Office 2010 32bit
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

Hi sjp1966

For column A, Select column or range of cells > Conditional formatting > New Rule etc.

Condition 1. Greater then equal to C1: =AND($A1<>"",$A1>=$C1) Format as required.
Condition 2. Less the C1: =AND($A1<>"",$A1<$C1) Format as required.

Same for Column B adjust cell references as required
Reply With Quote