Jobb1Excel
New Member
- Joined
- Oct 17, 2023
- Messages
- 22
- Office Version
- 365
- Platform
- Windows
Hey, im looking for a way to set cell color based on another cell color. I got 2 sheets and i use cell references from one sheet to the other.
I want the cells in sheet1 to be the same color (filled) as the cell references in the other sheet.
my cell references is pointed at the A row. So i want my =A1 cell to automatically be orange just like A1 in sheet2 and A3 to be white (Just some examples)
my cell with =A14 in sheet1 should be yellow.
I want the cells in sheet1 to be the same color (filled) as the cell references in the other sheet.
my cell references is pointed at the A row. So i want my =A1 cell to automatically be orange just like A1 in sheet2 and A3 to be white (Just some examples)
my cell with =A14 in sheet1 should be yellow.