Conditional formatting to color cells based on number

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

12-26-2016, 11:10 AM

kallard

Windows 10 Conditional formatting to color cells based on number

Office 2010 64bit

Novice

Join Date: Dec 2016

Posts: 3

Quote:

Originally Posted by Pecoflyer

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!!

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 02:30 PM.