Thread
: [Solved]
Conditional formatting
View Single Post
07-11-2016, 01:06 AM
otuatail
Windows 7 64bit
Office 2007
Competent Performer
Join Date: Jun 2012
Posts: 245
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.
otuatail
View Public Profile
Find all posts by otuatail