Use conditional formatting to highlight information

[Trang_DO]

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 !!!

[gsofo]

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.

[Trang_DO]

Hi, 

Thanks for your reply, I tried it but unfortunately it doesn't work.

I didnt understand why so I posted the question here...