Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Conditional formatting to color cells based on number
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 12-26-2016, 10:16 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Conditional formatting to color cells based on number Windows 7 64bit Conditional formatting to color cells based on number Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Replace your formulas like =AVERAGE(B277:B307) with =ROUND(AVERAGE(B277:B307),0).


Your CF will no work as required
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #2  
Old 12-26-2016, 11:10 AM
kallard kallard is offline Conditional formatting to color cells based on number Windows 10 Conditional formatting to color cells based on number Office 2010 64bit
Novice
Conditional formatting to color cells based on number 		 
Join Date: Dec 2016
Posts: 3
kallard is on a distinguished road
Default
Quote:
Originally Posted by Pecoflyer View Post
Replace your formulas like =AVERAGE(B277:B307) with =ROUND(AVERAGE(B277:B307),0).
Your CF will no work as required
Okay...this one is working. Thanks!!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formating all cells in an array based on adjacent cells deejay Excel 6 12-20-2016 12:00 PM
Conditional formatting to color cells based on number Sum cell by color that are conditional formatting ijewel Excel 1 03-16-2016 05:15 AM
Conditional Formatting based on Value of Another Cell SteveBump Excel 3 03-07-2014 09:16 AM
Conditional formatting to color cells based on number How can I count cells based on their fill color that was set by conditional format trueimage Excel Programming 1 10-25-2013 12:08 PM
Conditional formatting to color cells based on number Conditional color fill based on presence of data avanderh Excel 11 07-28-2011 09:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:01 PM.

Contact Us - Privacy Statement - Top

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