Showing results for 
Search instead for 
Did you mean: 

Alternate coloring based on a characteristic

0 Kudos

Dear Experts,

     We have a reuirement for having alternate colors for rows based on a characteristic. For eg. I have a candidate and his hobbies as listed below.

Please let us know if this is achievable and a way to achieve this.



Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

The following Post will surely help you.

You can take the basic Idea From here

Hope It helps 

Answers (1)

Answers (1)

Active Contributor
0 Kudos

Is your Candidate a Number or String?  If it is string then first convert it into number and use it in the Rule Formula else if it is numeric then use it as it.

Assuming it is string

Goto Analysis -> Conditional -> New Rule. From the Condition Drop Down select Formula Editor and put the below formula.


The click on Format and select Background and select the Color

Similarly Create one more rule with the formula


Select a different color for this.

Now click on the table columns and select Formating Rules and tick both the checkbox of Rule1 and Rule2 so that they are active on the table.