Microsoft Office Forums Conditional formatting not working with simple formula

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-17-2016, 10:08 AM
bendmc bendmc is offline Conditional formatting not working with simple formula Windows 7 64bit Conditional formatting not working with simple formula Office 2013
Novice
Conditional formatting not working with simple formula
 
Join Date: Nov 2016
Posts: 2
bendmc is on a distinguished road
Default Conditional formatting not working with simple formula


I am trying to highlight rows where column H is greater than 7 but its is not working. Rows are being highlighted where H>=7 and less that the highest number in the sequence. It looks like the formatted rows are moving up one row. See the attached picture for the formatting rule and the result. Any help on this problem would be appreciated.
Attached Images
File Type: png Conditional.PNG (85.2 KB, 7 views)
Reply With Quote
  #2  
Old 11-17-2016, 10:28 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Conditional formatting not working with simple formula Windows 7 64bit Conditional formatting not working with simple formula Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,387
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Could you please post a sample sheet
Perhaps try =$a$2:$I50000 as range to apply to but starting in row 2
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 11-17-2016, 11:31 AM
bendmc bendmc is offline Conditional formatting not working with simple formula Windows 7 64bit Conditional formatting not working with simple formula Office 2013
Novice
Conditional formatting not working with simple formula
 
Join Date: Nov 2016
Posts: 2
bendmc is on a distinguished road
Default

Fixed it. The rule has to start at the top of the area applied to so its $H1 not $H2>7. This slides down the formatting one row for some reason.
Reply With Quote
Reply

Tags
conditional formatting, highlight cells, rules

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting not working with simple formula Indirect not working in Conditional Formatting tinfanide Excel 11 06-21-2016 04:55 PM
Conditional formatting not working with simple formula Need conditional formatting formula namedujour Excel 1 05-27-2016 08:58 AM
Conditional formatting not working with simple formula Conditional Formatting Formula teza2k06 Excel 1 08-22-2014 02:49 AM
Conditional formatting not working with simple formula Formula/Conditional Formatting teza2k06 Excel 1 04-15-2014 06:49 PM
Conditional formatting not working with simple formula conditional formatting formula NEHicks503 Excel 1 11-30-2011 09:01 AM


All times are GMT -7. The time now is 06:37 PM.


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