Thread: [Solved] Dragging conditional formatting like a formula
View Single Post
 
Old 11-04-2012, 12:39 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

Select all of column B or a range of cells in column B, then go to new rule on the CF in the home tab.

Rule 1: =$B1>=320
Rule 2: =$B1<320
Reply With Quote