Highlighting Exception..

[abhi900]

Hi,

I have 2 fields ( Actual result) and (RunName).

I want to highlight (RunName) field whenever the related (Actual Result) field ISNULL.

The ACTUALRESULT is a MEMO DataType so when I Try to goto Highlighting Expert on RUNName field and try to put an exception I cannot see the ActualResult Field in there ?i mean not listed?
So I guess I have to make use of a formula, but how do I go abt it.

This is all under GROUPED by TESTNAME.

Regards

 

[fisheromacse]

create a formula
{@ARisNull}
if isnull({table.actualresult})
then 1
else 0

use this formula in your highlighting expert

 

[abhi900]

thanks soo mch mate.