Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Coditional formatting matrix values based on text field

Hi,   I have a matrix with categories on rows (blacked out) week num (1..52) and day (mon to sun) on columns and some dates as values when a submission was made..   I want to give backg...
Need Help
  • Alf94's avatar
    Alf94
    3 years ago

    Hi Anonymous ,

     

    First change the default background of your lines to red. Then add a conditionnal formatting to your dates used as values.

     

     

    You have to use the day field ("JourNom" in my report) in your conditionnal formatting.

     

     

    Finally:

     

     

    If I answered to your question, please mark my post as a solution.

     

    Best,

     

Alf94's avatar
Alf94
Solution Supplier
3 years ago

Hi Anonymous ,

 

First change the default background of your lines to red. Then add a conditionnal formatting to your dates used as values.

 

 

You have to use the day field ("JourNom" in my report) in your conditionnal formatting.

 

 

Finally:

 

 

If I answered to your question, please mark my post as a solution.

 

Best,