|
|
|
|
#1
11-05-2012, 12:02 AM
|
|||
|
|||
Hi sjp1966
In cells: B C 1 320 75 2 768 75 3 36 75 Select cells C2 - C4 ensuring the active cell is C2: Home Tab > CF > New Rule RULE 1: =$B2>=320 Rule 2: =$B2<320 Adjust your ranges etc to suit your needs 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel Formula - Conditional replacement of cells | mag | Excel | 0 | 10-27-2012 08:30 PM |
| Conditional Formula | UICOMP | Excel | 1 | 05-18-2012 12:59 PM |
| Need formula for search and conditional formatting | MikeJedi | Excel | 9 | 01-13-2012 12:38 PM |
 conditional formatting formula
|
NEHicks503 | Excel | 1 | 11-30-2011 09:01 AM |
|
Conditional formatting with AND, OR
|
Lucky | Excel | 2 | 10-03-2011 11:41 PM |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode