Solved Excel Conditional Formatting - Colours

January 5, 2017 at 01:31:07
Specs: Windows 7
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

See More: Excel Conditional Formatting - Colours

Report •

January 5, 2017 at 02:49:47
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.

Report •

January 5, 2017 at 08:24:29
✔ Best Answer
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.

Please explain, in detail, using Cell References with Column Letters and Row Numbers what it is your trying to do.


message edited by mmcconaghy

Report •
Related Solutions

Ask Question