Conditional Formatting a Range

Phil H · #1 02-17-2016, 07:26 AM

Need a CF formula for the range AG3:AG32.

If any of the cells is blank, or less than or equal to the value in cell AG2. Trying =IF(OR(ISBLANK(AG3)),<=(AG2)) but it doesn't work.

gebobs · #2 02-17-2016, 07:45 AM

Split it up into two conditions. See attached.

Phil H · #3 02-17-2016, 08:17 AM

Thanks. This works. Didn't realize CF wouldn't accept an OR formula.

gebobs · #4 02-17-2016, 08:33 AM

Quote:

Originally Posted by Phil H

Thanks. This works. Didn't realize CF wouldn't accept an OR formula.

I'm pretty sure I've used ORs in conditional formatting. I don't think that's the problem.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting	bbutl027	Excel	15	12-05-2016 08:56 PM
VBA Conditional Formatting Error (Subscript out of Range))	tinfanide	Excel Programming	1	05-15-2015 08:12 AM
Conditional Formatting - color only dates contained in a range	EC37	Excel	1	07-08-2014 12:51 PM
Conditional formatting that ignores other formatting rules	info_guy2	Excel	1	07-03-2014 10:07 AM
Conditional Formatting	teza2k06	Excel	3	01-19-2014 02:34 AM