Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Conditional Formatting % Values ONLY

Hi Experts   I am trying to format in White Font Colour the Metrics that start with a % sign in my Table. I have in the Logistics Table a Column OrdNo where i have assigned a 1 for % values and 0 f...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi,

    if I understand it correctly, you can do it like this,

    First, you create a column;

    Find % = IF(LEFT(Logistics_[New_Reporting_Headers],1) = "%" , 0 ,1)
    then you can apply condition; I use yellow and red color