In MsAccess 2007,I want each row color to change based on a column value in the report.
For example: Select Name,Age,Salary from table 1 -creates 3 rows.
Name Age Salary
A 15 1000
B 25 2000
c 35 3000
if Salary column is less than 1001,row should be in red- Row 1
if Salary column is less than 2001,row should be in green -Row2
if salary is less than 3001, row should be orange-Row3 .
How to do conditional color formatting of the entire row in Msaccess2007 based on a column value of each row. Please help