Forum Discussion

dd88's avatar
dd88
Icon for Post Patron rankPost Patron
2 years ago
Solved

Conditional formatting on Age >17.75

In an Excel spreadsheet, columns exist for Date of birth Age Column Age stores the persons age and contains a formula with Conditional Formatting If Age value >17.75 highlight in colour Red. I...
Need Help
  • dd88's avatar
    dd88
    2 years ago

    Thank you Anonymous 

     

    Now resolved, I used the following condition to get it working ..


    If value => 17.5 number and <=100 number then Red

     

    The condition is,

    if Age is greater than or equal to 17.5 and less than or equal to 100 (years age), then Red.

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, dd88 

You can refer to HarishKM reply. IF it does not work, you can try following method.

Method 1 :


Change the portion of the box to 100 Percent.

 

Method 2:
Use Measure

 

Measure:

 

Age2Color = IF(SELECTEDVALUE('Table'[Age2])>=17.75,"Red")

 

Effect:


Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum





dd88's avatar
dd88
Icon for Post Patron rankPost Patron
2 years ago

Thank you Anonymous 

 

Now resolved, I used the following condition to get it working ..


If value => 17.5 number and <=100 number then Red

 

The condition is,

if Age is greater than or equal to 17.5 and less than or equal to 100 (years age), then Red.