Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In the expression properties >> click on Plus sign >> and in the Background Properties >> write expression (=If( sales >3000, Red(),Green())
Regards
Anand
try this
if(sum(sales)>3000,red(),green())
It showing like RGB....not showing color
In the expression properties >> click on Plus sign >> and in the Background Properties >> write expression (=If( sales >3000, Red(),Green())
Regards
Anand