I have some data to analyze, now if have to check for some values in a column.
If the column contains 6008 the row should be red, and if its 7003 it should be green, 5008 orange, etc
And well some more colors based upon values on that single column.
How do i accomplish this ?
(i have no experience with macro’s in calc, i am a programmer, but using it just for 2 weeks)