Conditional formatting

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional formatting

FAQ

Thread Tools

Display Modes

07-11-2016, 01:06 AM

otuatail

Windows 7 64bit Conditional formatting

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.

« Previous Thread | Next Thread »

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.