Thread: [Solved] Dragging conditional formatting like a formula
View Single Post
 
Old 11-05-2012, 12:02 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
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
Reply With Quote