Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I would like to Use conditional formatting to highlight information in a table.
The problem is when I change the filter, the value which is used to fix the condition is changed also and the colour isn't right.
Ex : =if([Taux succès par nb logement]<=0.48,Red(),Green())
I would like to make 0.48 in dynamique
Could you please help me to solve the problem ?
Thanks so much for your help !!!
Depending on how you want to do it, I'd either make the 0.48 a variable or a formula calculation like
=if([Taux succès par nb logement]<=(FieldA/FieldB),Red(),Green())
=if([Taux succès par nb logement]<=vVariable,Red(),Green())
You'd have to define the variable first but would achieve the same result. I'm not sure how 0.48 is determined.
Hi,
Thanks for your reply, I tried it but unfortunately it doesn't work.
I didnt understand why so I posted the question here...