Can anyone shed any light?
I am using this formula for my conditional formatting on column X =IF(AND($X5>0,$N5=""),1,0)
However column X values are formula driven, with a the result being "" if false. Therefore the conditional formatting is still applying even if X5 = 0 (i only want it to apply if bigger than 0), can anyone help?
Thanks in advance! I am not very excel savvy and 1st time posting so bear with :D
Bookmarks