Excel base condition

[Anonymous]

Hi All,

Currently, I am making condition formating on excel but later I am going to apply similer to Power BI.

I unsolve and solved picture which I am looking for. I want to use color condition.

Unsolve screen short.

Solved Screen short

I tried IF and OR condition but I am still not get there. I want to show yellow in cell amount if there is any two number come cell at same time. It does not matter what number come. But if there is no amount like zero than color must be white and if only one cell have amount than also white. 

If any one could help will be appreciated.

Thanks

[amitchandak]

@Anonymous , not very clear. But you can use color measures. Here based on multiple conditions you return to color and then use that color measure in conditional formatting of a column/s using the field value option

color value example

Color  = if(FIRSTNONBLANK('Table'[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170 
,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))
Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")

color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)

refer

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[Anonymous]

Hi Amit,

Currently, this is excel problem which I want to solve. I tried with less than or equal to or IF AND and OR with condition on excel, but still not get there.

I just do not want round circle number to be yellow as per below: