Excelneewbie11
New Member
- Joined
- Mar 20, 2022
- Messages
- 1
- Office Version
- 2013
- Platform
- Windows
Hey there, I'm a complete newbie with excel but I've been learning quite a bit over the past few days and I'm impressed at the amount of ways excel can be used to organize data!
My current workbook contains an "overview" sheet and then several other sheets organizing data (each row is an item with the columns specifying info on that item) with copied conditional formatting so each page other than the overview is essentially identical. In these secondary pages I have a column with due dates that causes the date cell to be filled with different colors based on how close to the date in the cell I am at the time (today()+ etc formulas). what I am looking to do is somehow link a range of cells on the overview worksheet to the date triggered cells with color CFs so that when the single cell turns orange it will pull the data from that row into the range specified on the overview worksheet. Is this easily done or am I in way over my head? thanks for any assistance.
My current workbook contains an "overview" sheet and then several other sheets organizing data (each row is an item with the columns specifying info on that item) with copied conditional formatting so each page other than the overview is essentially identical. In these secondary pages I have a column with due dates that causes the date cell to be filled with different colors based on how close to the date in the cell I am at the time (today()+ etc formulas). what I am looking to do is somehow link a range of cells on the overview worksheet to the date triggered cells with color CFs so that when the single cell turns orange it will pull the data from that row into the range specified on the overview worksheet. Is this easily done or am I in way over my head? thanks for any assistance.
