Any question answered...

You are reading a single comment by @deleted and its replies. Click here to read the full conversation.

•

deleted
I'm confused.
Where should I be dropping it?

I have a clunky macro with loads of little functions in it to colour code cells based.

there's other bits, but the bit I'm playing with is this:

Range("b3:B" & LastRow - 1).Select
Selection.FormatConditions.Delete
```
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=IF(AND(ISBLANK(CH3)),(CQ3>=CF3+365))"
Selection.FormatConditions(1).Interior.ColorIndex = 3
```
(so if CH3(a follow up) is blank and CQ3(date I extracted data) is > than CF3(when last seen) +365(a year ago) the cell goes red.
and
then

Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
```
'"=if(or(and(countblank(C3:CG3)=1,AS3 = ""Method C"",AT3 = ""),countblank(C3:CG3) = 0)"
```
Selection.FormatConditions(2).Interior.ColorIndex = 3

if anything within the range C3:CG3 is blank (apart from AT3 when AS3 = "Method C") it also goes red. And the people I need to see this can see "oh shit, I need to look at those red records".

About

@deleted started