say there are 5 columns
1.) riskconvergence date
2.) penddate
3.)issue status
4.) issue name
5.) issue description
i need a condition where
if risk convergence date between first of (pendate)month) and (pendate))
then green
else if (issue status)=pending
then pink
else
yellow
how i did it is
if ((risk convergence date) between (_first_of_the_month(pendate)) and (pendate))
then ('green')
else if (issue status)=pending
then ('pink')
else ('yellow')
i want all columns of the list should formatted from above condition .plz help its urgent and thanks in advance
Take a look at conditional styling:
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_rptstd_fin.8.4.0.doc/ug_rptstd_fin_id3759cr_rptstd_modrep_highlight_data_con.html