Microsoft Office Forums - View Single Post - Conditional formatting to color cells based on number

Thread: Conditional formatting to color cells based on number

View Single Post

Old

12-26-2016, 11:10 AM

kallard

kallard is offline

kallard uses Windows 10

Windows 10 kallard uses Office 2010 64bit

kallard uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

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