Thread: [Solved] Conditional formatting
View Single Post
 
Old 07-11-2016, 01:06 AM
otuatail otuatail is offline Windows 7 64bit Office 2007
Competent Performer
 
Join Date: Jun 2012
Posts: 245
otuatail is on a distinguished road
Default

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.
Reply With Quote