Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 11-04-2012, 02:43 AM
sjp1966 sjp1966 is offline Dragging conditional formatting like a formula Windows XP Dragging conditional formatting like a formula Office 2007
Novice
Dragging conditional formatting like a formula
 
Join Date: Mar 2012
Posts: 21
sjp1966 is on a distinguished road
Default

hi Grizz. I am sorry I must be quite stupid here, but it doesn't work.

B2 = 320 C2 = 75
B3 = 80 C3 = 75
B4 = 36 C4 = 75

1st thing I do under new rule is click on C2 and do if cell value is less that B2 colour it red, when I check the rule is is

cell value <=A1
Format (font is red)
applies to = =$B$1

if I try and remove any of the $ from applies to, it puts them back when i hit apply

when I drag the handle down the applies to area showsd the range but it will only every use A1 as the cell to take information from, I need to to go to B1, C1 and so on.

when i do what you suggest below the cells in C are blank and also i dont need anything in Cell C, I need the number in Cell B to be red or green depending on if it is higher than the cell to its left.
Reply With Quote
 

Thread Tools
Display Modes


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
Dragging conditional formatting like a formula conditional formatting formula NEHicks503 Excel 1 11-30-2011 09:01 AM
Dragging conditional formatting like a formula Conditional formatting with AND, OR Lucky Excel 2 10-03-2011 11:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft