Here is an example of using one format to display given text for a range of values and then color the cell based on the same range of values. You should be able to run this code as the SASHELP.CLASS data set is provided by SAS as a training set.
proc format library=work;
value heightgrp
100 - high = '+'
other = ' '
;
value backcolor
100 - high = 'red'
other = ''
;
proc report data=sashelp.class;
columns sex age height;
define sex/ group;
define age/ group;
define height/ format=heightgrp. style={cellwidth=1.in backgroundcolor=backcolor.};
run;
... View more