Made a post before but it was a mess since this is my first visit to this forum and I could not edit my post.
So I try again - sorry about that!
I have made a script that creates a csv file, and updates it every hour with new data added first in row and not last.
How can I change the background color of cells in column if the new value is greater or less than the previous one?
So, if new value is greater than the previous make the color green, if value is less than previous make it red.
Since I am learning, green and red will be sufficient for now, later on I will try make it more gradient , if possible =)
Many thanks in advance!
new.ods