Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
i got about 20 values in a field called que ,which i am displaying in a straight table , among those 20 values i want two values colored green.so i wrote below expression in Text Color ,which is not working
=if(que='Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?' ,if(que='Has the sampling processes found to be satisfactory ?', green() ))
i known something wrong with my expression ,can any one suggest me
thanks
naveen
Hi Naveen,
Try:
=if(
que='Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?'
or
que='Has the sampling processes found to be satisfactory ?', green())
Your original expression would only return Green() if que equaled both of the two strings which since the strings aren't equal will never the true.
Cheers
Andrew
Try this
=if(que='Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?',red(),
,if(que='Has the sampling processes found to be satisfactory ?', green(),black() ))
Hi Naveen,
Try:
=if(
que='Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?'
or
que='Has the sampling processes found to be satisfactory ?', green())
Your original expression would only return Green() if que equaled both of the two strings which since the strings aren't equal will never the true.
Cheers
Andrew
HI
only the red colored values is displayed with above exp,the other one not is displaying in black color
only the red colored values is displayed with above exp,the other one is displaying in black color
the other value in BLACK color
Hi naveen,
Tit should be work,
if(que='Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?'
or que='Has the sampling processes found to be satisfactory ?',green() )
Hi Naveen,
Try like this:
=pick(Match(que,'Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?' ,'Has the sampling processes found to be satisfactory ?'),green(),green())
Regards
KC