Forum Discussion
excel
I'm tracking expiration dates. I have my expiration cells date setup to change color from "Green to Yellow to Red" as my expiration its closer. I would like for other cells to change to the same colo...
YES, i'm using conditional formatting to color expiration date.
NOT the same cells; but in the same row; like row # 11
You may apply to your range rules with formulas like (for red)
=$A2<TODAY()
similar for other colors, just be careful with absolute and relative references. Please check attached.
Let me try that.
Thanks for your help.