|
|
#2
02-10-2013, 01:30 AM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| conditional formatting | otuatail | Excel | 1 | 06-06-2012 05:07 AM |
| Conditional formatting | zanat0s | Excel | 4 | 01-20-2012 03:30 AM |
 Conditional formatting with AND, OR
|
Lucky | Excel | 2 | 10-03-2011 11:41 PM |
| Conditional Formatting | namedujour | Excel | 3 | 08-25-2011 01:46 PM |
|
help with conditional formatting
|
Snvlsfoal | Excel | 3 | 07-03-2011 11:55 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode