creating one cell with dferent coluring percentage

marinTz

Hi
i need to creat 1 cell with deferent coloring percentage.
the coloring of the cell should be dependent between the rows


for example i have some school cariculum.
each day has deferent amount of learning hours.
in each day i have deferent amount of hours for english and for math.

on sunday we had 6 hours 3 of them english 3 math
on monday we had 4 hours 2 of them english 2 math


so i want my out put report to have 2 lines, one for sunday one for monday.

and the overtime cell should be colured on the first row: 50% green(english),50 red(math).the second row over time cell should be 30% green(english),30%red(math), 30% no colur(should be aligned with the first row with 6 hour)

johnw

You can use the Highlight for the cell, and base it off of the expression (row["mathHrs"] / row["totalHrs"]), where mathHrs is a column containing the hours spent in math, and totalHrs is a computed column with mathHrs + englishHrs + otherHrs.