![]() |
|
#1
|
|||
|
|||
![]()
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. |
#2
|
|||
|
|||
![]()
Split it up into two conditions. See attached.
|
#3
|
|||
|
|||
![]()
Thanks. This works. Didn't realize CF wouldn't accept an OR formula.
|
#4
|
|||
|
|||
![]()
I'm pretty sure I've used ORs in conditional formatting. I don't think that's the problem.
|
![]() |
Tags |
conditional formatting, isblank |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Conditional Formatting | teza2k06 | Excel | 3 | 01-19-2014 02:34 AM |