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...
Hi Kevin,
Are "other cells" in the same row as expiration date?
Do you use conditional formatting to color expiration date?
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.