column header font color change based on value from another column

[jcastr02]

Is there a way to conditionally format the column headers in a table based on the values from another column.  For example, I'd like for where it states (DE, DR, or PCC in the top table) if those show Y, then the respective bottom one would have Green font, but if shows N, then the font color is red.

[jcastr02]

@amitchandak    I thought of perhaps adding a shape over the header & brining it to the front to at least get the color of the header background changed  based on it - and put an if statement If yes, turn green, if not leave red, but not sure where I would place the measure on the shape to get the shape to change color?

[amitchandak]

@jcastr02 , The column header color, do not have conditional formatting(Fx) option, so I doubt we can do that