Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table box like this :
ID Value
A Removed
B Keep
C Removed
D
E To Remove
And I would like to put in green cells with the value Removed.
I try to use the calulated format with the formulas in the "Custom Format Cell" with the formulas if(value='Removed',RGC(128,255,128),(255,255,255)), but it's ok If I select only rows with Removed, but when I have the full table box, All cells are blanks even if cells with Removed.
Sylvain
Hi.
TableBox is just for debug ourpouses. If you want to add formating formulas use chart > straight table.
Hi.
TableBox is just for debug ourpouses. If you want to add formating formulas use chart > straight table.
try like below
exp- pick(WildMatch(Value,'*Removed*'),RGB(128,255,128),RGB(255,255,255))
Thanks for your answer. I use the straight table instead of the table box