Forum Discussion
Double condittional formatting
Hello, I'm trying to get a double formatting (I know I can use Project but I need to make calculations in my data sheet).
My first condittional formatting shows colored cells in the Gantt chart to the right, it comes from adding the format if the values of the cells are between C and E columns. But I want to make the color of the bars depending on the value of the cells in H column, I mean if the task is Open the bar must be red and so on (Keeping the dates of course).
Yes. I prefer SergeiBaklan answer to Daniel Misael ARTEAGA
Hi Daniel,
You may use 3 rules instead of your current one - add to your rule through AND condition comparing with each of 3 statuses (one status per rule) and apply desirable color.
