Conditional formatting

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional formatting

#10

07-11-2016, 01:29 AM

Kevin@Radstock Kevin@Radstock is offline

Windows 10 Conditional formatting

Office 2016

Office 365

Join Date: Feb 2012

Posts: 94

Hi

How about in G3:

=IFERROR(SUM((A3+$K$2)/(B3-2)),"")
or
=IF(ISERROR(SUM((A3+$K$2)/(B3-2))),"",SUM((A3+$K$2)/(B3-2)))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting	dayperson	Excel	1	02-23-2016 09:07 AM
Conditional formatting	marif300	Project	9	09-23-2014 07:23 AM
Conditional formatting that ignores other formatting rules	info_guy2	Excel	1	07-03-2014 10:07 AM
Conditional Formatting.	Laurie B.	Excel	6	04-09-2012 05:01 PM
Conditional formatting	zanat0s	Excel	4	01-20-2012 03:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:08 PM.