I have a report that I would like to have a field highlight when data is present...or when the field is not blank.
I have found numerous fixes to hightlight a field when it is null or blank...is there a way to do the reverese?
Thanks in advance!![]()
I have a report that I would like to have a field highlight when data is present...or when the field is not blank.
I have found numerous fixes to hightlight a field when it is null or blank...is there a way to do the reverese?
Thanks in advance!![]()
OK, I kept playing around and found the solution. Go to condtional formatting, select new rule and use Field Value Is Not Equal To "blank"...then select the color you wish to use to highlight the field...this will hightlight the field when information is present.
Thanks!