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 color as the expiration date cell as it changes. The other cell may have stuff like names, ID numbers, etc.…..
4 Replies
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.
