Thanks for helping out. Will move the discussion as mentioned in the link
- Sai Vijay
Shawn and Sai... I have a different kind of requirement but on a higher level this falls into cell formatting only.
i can do conditional formatting based on maximum 1 condition.
1- Can we have color formatting based on multiple condition.
Ex- Col 1 should be formatted based on defined threshold, similarly for Col2 and Col3 etc. so each column would be formatted based on their individual conditions.
2- i want to show Last Year and Current Year values and another column which will have a shape filled with red/Green based on my condition. But this needs to be done in one sheet only. Can you please suggest if you have faced similar situations.
Thanks and Regards,