Excel 2003: Using a formula to copy formatting (ie: background colour)
Posted on 2010-11-25
Hey there - Conditional Formatting is not cutting it for me right now because of the 3 conditions limit. I would like to shy away from a VB=based solution, because:
A) I don't want any issues when sharing my worksheet
B) I don't want to have to run a macro each time I change a value
Essentially what I'm hoping I can do is:
- On Worksheet A, put a different background colour in each cell (A1..A5)
- On Worksheet B, I have a formula in a cell that looks at the number in that cell (1 to 5) and based on that number, use the colour from the corresponding cell in Worksheet A
- eg: in Worksheet B, if I put a "2" in the cell, it will fill that cell with the colour found in WorksheetA:A2; if I put a "5" in the cell, it will fill the cell with the colour from WorksheetA:A5.
The problem is, I haven't found any functions in Excel that deal with the formatting of a cell, as opposed to the data.
Please bear in mind this is Excel 2003, so I can't use conditional formatting, since I need more than 3 different colours.
Thanks for you advice!