Table Alert (Green and Red)

[#1]

Hi

I have table report like

Year,Total Sales.

If sales >3000 means then my record should display red cell else green.

How can i achieve this.

Thanks

Govind R

[arulsettu]

try this

if(sum(sales)>3000,red(),green())

[#3]

It showing like RGB....not showing color

[its_anandrjs · Accepted solution]

In the expression properties >> click on Plus sign >> and in the Background Properties >> write expression (=If( sales >3000, Red(),Green())

Regards

Anand