Forum Discussion
IFS OR FUNCTION IN EXCEL
Dear Friends, help me on below. i have 2 years data like 2019 and 2020, So here i wanna to apply 3 condition.. GREEN, AMBER, RED GREEN Values should be more then <=0.50, AMBER Valu...
Pls check the conditions again,
Green - x >=0.50
Red - x <= 0.01
Amber - x between 0.02 to 0.49
If this conditions are correct then you can easily do this with conditional formatting.