I'm wanting to know if there is a way for a cell in one tab to change to the same colour as a cell on another tab automatically on Excel 10
Not that I'm aware of as formatting usually doesn't include colours, the default is black in Excel unless you manually change it in each cell.
Phil22, sorry to have to correct you, Using Conditional Formatting, It is possible, but you also need to use Defined Names.
It's tricky, but can be done.SJCumb1972:
Please explain, in detail, using Cell References with Column Letters and Row Numbers what it is your trying to do.message edited by mmcconaghy
Yes (14) | ![]() | |
No (14) | ![]() | |
I don't know (15) | ![]() |