Forum Discussion
Conditional Formatting
I have a column with location data (5 different locations) and when I choose a location the cells in that column change fill colour. This is easy. What I want to do is then change the fill colour in ...
Conditional Formatting will only apply colors pre-defined by you.
By creating a Macro, it is possible to apply customized colors will be applied to the respective rows (based on location).
Eg. INDIA, USA, UAE, AUS, AFRICA are 5 locations.
By using macro, if you apply color you want to that any location of above, it will apply colors to the respective rows for that location.
If you apply (green) to INDIA, it will apply green color to the rows where location is INDIA.
Which way you want Macro or Conditional Formatting(without Macro)?
THanks I will try this