Forum Discussion
Is it possible to format the fill color of a cell to equal the fill color of another cell?
I have a spreadsheet with with columns conditionally formatted to fill (highlight) based upon the text of another cell. For example, the formula in C3 is '=$E$2', and if E2 contains "STS" the Condi...
This is disappointing... I have been looking for the exact same answer for weeks! Unfortunately, the responder was not understanding the problem, therefore this is still unanswered. I so hope the correct answer emerges. I thought for sure that this would be a simple solution, but no.... It's a mystical Quest.
Can anyone find the answer!?!?
I assume that I was the responder.
Can you describe your problem in detail? Thanks in advance.
- So I am creating a schedule from scratch. The idea is that in column A, the start time for a 15 minute break is found. ie, 10:00 am, we'll call this A5. This has been conditioned to highlight a cell within a table, in a cell valued at 10:00 am, we'll call this J5. This works...
The table is incremented in 5 minute intervals. The next 3 adjacent cells are, you guessed it, 10:05 am, 10:10 am, and 10:15 am. I'm trying to get those following 3 cells to highlight as well BECAUSE the cell value 10:00 am IS highlighted through CF. If it were any other time of day, also a value found in column A, the next 3 cells (or a combined 15 minute time slot) is highlighted. I can't just change the increments to 15 minute intervals because at some point only 10 minutes will be highlighted (or two 5 minute value cells.) I would rather not have to manually highlight the cells that follow J5 as the values found in column A will change. (A5 could hold a value of 10:15 am) If there is an easier solution, I'm open to suggestions.
Using a template is out of the question...Thanks. Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- I'm sorry, but I am not able to do that. The question is, can I use CF (or another method) to highlight J16 BECAUSE J15 was highlighted through CF?
OR
Highlight [J15(+2 cells to the right)] without having to do it manually?