Conditional Formatting

[mmt4331]

The following is what I have on my report:

Assigned_By Assignee Resolution Who_Acknowl

MMT4332 00077714 Completed MMT4331
MMT4332 00077323 Pending
MMT4332 00077534 Completed
MMT4332 00077533 User Resolved MMT4332


The two middle rows that have nothing under - Who_Acknowl - I would like to make the Assigned_By, Assignee, and Resolution fields red. The Who_Acknowl field that has something showing I would like to leave at black. How do I do this? Thx.

Mark

 

[rscero]

In the format font section for the fields you want highlighted red, add code similar to the following:

if IsNull(Who_Acknowl) then
Color (255,0,0)
else
Color (0,0,0)

You may also need to check for Who_Acknowl = ''.

 

[mmt4331]

Rscero:

Thx for helping me out there. It works perfectly.

Mark