Colorize a number in a column/row in a summary report
Hi There,
I have a summary report that displays 3 columns; months, dollar amount scheduled or completed, and our dollar amount goals. The rows are broken down by each month of the year. I would like the "amount" number for each specific month to be colored red or green. The "amount" number for each month should be Red IF the amount number is less than the number in the Goal column for that month. The "amount" number should be Green IF the amount number is greater than the number in the the Goal column for the specific month.
Is this possible to do with the new report formulas feature?
Thank you for your help. I've attached a picture for your reference.
I have a summary report that displays 3 columns; months, dollar amount scheduled or completed, and our dollar amount goals. The rows are broken down by each month of the year. I would like the "amount" number for each specific month to be colored red or green. The "amount" number for each month should be Red IF the amount number is less than the number in the Goal column for that month. The "amount" number should be Green IF the amount number is greater than the number in the the Goal column for the specific month.
Is this possible to do with the new report formulas feature?
Thank you for your help. I've attached a picture for your reference.
