Conditional formatting to color cells based on number

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional formatting to color cells based on number

FAQ

Thread Tools

Display Modes

12-26-2016, 10:16 AM

Pecoflyer

Windows 7 64bit Conditional formatting to color cells based on number

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

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

« 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
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
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 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 06:39 AM.