Forum Discussion
SUDHAKAR-FRONTIER
Jan 18, 2021Brass Contributor
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...
Riny_van_Eekelen
Jan 18, 2021Platinum Contributor
SUDHAKAR-FRONTIER I believe you received an explanation of the basics for these kind of calculations here:
https://techcommunity.microsoft.com/t5/excel/ifs-negative-values-error/m-p/2066337
Do you now want to conditionally format the cells with a colour (Green, Amber or Red) in stead?
SUDHAKAR-FRONTIER
Jan 19, 2021Brass Contributor
not colour Riny, its green, amber, red want to display..