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 •

#1
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 •

#2
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.

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

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •
Related Solutions


Ask Question