Forum Discussion
Conditional formatting background_empty cells
Hi, Need help with conditional formatting. I have a table with activities and statuses (closed/open). So I added this measure (called Measure) but it gives value 2 to blank cells as well: Measu...
Hi, Anonymous
According to your description, I think you can create a measure, It only judge the two states of open and closed.
like this:
Measure = IF(MAX('Table'[Status])="open","Red",IF(MAX('Table'[Status])="closed","Green"))//Omit blank()Then use it in condifitional formatting.
Like this:
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,Community Support Team _ Janey
Hi, Anonymous
According to your description, I think you can create a measure, It only judge the two states of open and closed.
like this:
Measure = IF(MAX('Table'[Status])="open","Red",IF(MAX('Table'[Status])="closed","Green"))//Omit blank()Then use it in condifitional formatting.
Like this:
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey