sheet 2 contains student name and student total marks
My requirment is if i click student name in sheet 1 it show student name and student total marks in sheet2 but i need to highlight student name field bg color and font color. actually i have no of colums that why i need to change colors dymically ex : if i click 'x'(y,z...) field it display in sheet 2 with formated as student name.
In dimension of chart you will be able to see the plus sign..click on it and you will find options to change background color and text color.You can add dynamic colors based on requirments.
