backround color 1

[Newbi1]

I am trying to create a grid layout which there is conditional backround color of a field in CR 8.5.

If left({procRptSummaryBySiteGradeSpan;1.vcProResult},3) = "yes" then green
else
if {procRptSummaryBySiteGradeSpan;1.vcProResult} = "No" then Red
else

What would I place in here if I want no backround if neither of these conditions exist? The problem is I have the field flush again the grid and when there is a white backround, it blanks the grid lines.

 

[Turkbear]

Hi,
Have you tried:

If left({procRptSummaryBySiteGradeSpan;1.vcProResult},3) = "yes" then green
else 
if {procRptSummaryBySiteGradeSpan;1.vcProResult} = "No" then Red
else
NoColor

To Paraphrase:"The Help you get is proportional to the Help you give.."