So im a bit stuck trying to figure out how to do conditional formatting for industries that have a list of companies, each industry has a favorable leverage ratio. I cant seem to figure out how to show those that have a favorable and unfavorable ratio for each industry.. any thoughts??
You would need a reference to know what's favourable or not right ?
Is the reference a parameter that the user can change or something in the data (maybe the avg of all the ratios) ?