Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there
I'm trying to do a conditional format where I take the null or empty values and highlight with a particular color.
if
(IsNull(sum(Units/[Units/Case]), rgb(119,136,153)))
didn't work
Your help would be appreciated.
try this it may help u
if(sum(exp)=null(),rgb(119,136,153)
hi srikanthsri1
i tried as you suggested, still didnt seem to work, i tried it in the attached document.
my syntax was the following:
if(sum([Units]/[Units/Case])=null(),rgb(119,136,153))
Thanks
may this might help you