Solved: Conditional Formatting

Niraj_vora0106 · ‎06-06-2022

Hi community,

I've a doubt regarding Conditional Formatting.

Suppose I've a column Year, in that I've two values FY20 and FY21.

Is it possible to give conditional formatting like Background colors or Icon only to FY20?

Because as much as I know Conditional formatting works for whole particular column rather than single values inside it.

Please help!

v-zhangti · ‎06-09-2022

You can try the following methods.

Color = IF(SELECTEDVALUE('Table'[Year])="FY20","Green",BLANK())

Does this meet your desired outcome?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti · ‎06-09-2022

You can try the following methods.

Color = IF(SELECTEDVALUE('Table'[Year])="FY20","Green",BLANK())

Does this meet your desired outcome?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎06-06-2022

You can set a rule like:

If Year = FY20 then *select the icon*

You don't need a rule for the FY21

Conditional Formatting