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 Conditional Formatting will Highlight C3 Red, or if E2 contains "SS", Conditional Formatting will Highlight C3 Yellow, etc. (with 12 text conditions equaling 12 different colors.)
I would like B2 (which contains an "@" text) to match the Highlighted color of C3.
Is that possible? If so, how? I've spent hours trying to figure this out and you all are my last hope.
Thank you in advance for any guidance.
Select B2.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula =$E$2="STS"
Click Format...
Activate the Fill tab.
Select red.
Click OK twice.
Repeat these steps, but with =$E$2="SS" and yellow as fill color.
Etc. etc.
- Hi Hans!!! I've already created the Conditional Formatting based upon the Text however, I'd like the adjacent Cells color to change when C3 changes (based upon the E2 content). So when C3 changes to Yellow, I'd like for B3 to change to Yellow too. I hope that makes sense. 🙂
You'll have to create as many rules for B3 as for C3 - as described in my previous reply.
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...
