Hi
I've read through all the posts I can find however I can't seem to find one that helps me work out where i'm going wrong.
This is what i currently have =IF(B2:B8="Y",char(80),IF(AND(D3<$A$1,B2:B8<>"Y"),CHAR(39),CHAR(137)))
Here's what i'm trying to achieve
If ALL cells in the B2:B8 range...