Timeline for Change cell color of a range of cells based on data in another column
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 28, 2018 at 9:29 | comment | added | Ceu Melo | @Steve I'm sorry, but I still don't understand what you need. You wish to paint the next cell of the same dates with the same color? That is, every time date A shows up, the next cell will be green; every time date B shows up, the next cell will be red; and so on? | |
| Feb 28, 2018 at 5:31 | comment | added | Steve | That might be close to a partial solution. By checking to see if the date value is different than the one above it and returning a 1 if it is, you can then sum those 1s and check for an odd or even condition to then set the color based on known possibilities rather than on unknown dates. Now just need to spread that across each row individually and make sure it can be expanded as new dates are added. | |
| Feb 28, 2018 at 4:59 | comment | added | Steve | Interesting - but no. I am not just looking for the first occurrence of a date - they are sorted anyway. But that might be a partial solution. | |
| Feb 26, 2018 at 14:30 | history | edited | Ceu Melo | CC BY-SA 3.0 |
added 245 characters in body
|
| Feb 26, 2018 at 14:22 | history | answered | Ceu Melo | CC BY-SA 3.0 |