Forum Discussion
Solved
Multiple Conditional Formatting based on MONTH()
Hi, I am trying to create a conditional formatting that will create unique color for each month on Column C. Column A is the DATE value in short format Column B sets the YEAR based on calculatio...
Try this formula in C2 and fill down.
=DATE(2000,IF(A2>=DATE(YEAR(A2),10,15),1,MONTH(A2)+1),1)
Apply a standard color scale.
MSegas Perhaps I misunderstood, but the CF rules for column C could be like this:
=MONTH($C2)=1
=MONTH($C2)=2
=MONTH($C2)=3
and so on.
- Humm, I did not try that, but the answer from Hans Vogelaar, worked.
