|
|
|
|
#1
07-11-2016, 12:35 AM
|
|||
|
|||
That is not exactly correct. Look at it today. If you change the value in cell D3 so that the divide by zero moves to F3 then...
G3 will not be a divide by zero as it is a divide by -1 now. -1 is less than one isn't it. 
|
|
#2
07-11-2016, 01:06 AM
|
|||
|
|||
|
I have posted a sheet that shows the problem fully
Here if Error display in orange If less than 1 display in orange =or(type(G$3)<>16,G$3>1) Row 3 should fail the conditions as divisor is greater than 1. Should be blue.
|
|
|
|
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 |
Windows 7 64bit 
Office 2007
Hybrid Mode