Conditional Formatting by row
I often come across instances where I need to heat map a lot of lines of data using heat map option in conditional formatting. However to do this by row I have to select a row at a time. I tried to do a via script but my scripting skills aren't great. Could we get a option where we can do the heat map by all data (currently available) as well as heat map by row of data? heat map by column may be useful for some also.
Happy to be contacted too explain further/upload examples.