Color range from other sheet

  • Thread starter Thread starter yh73090
  • Start date Start date
Y

yh73090

Is it possible to color a range on sheet 1 from sheet 2?
If I enter a key number can that generate a range it will color o
another sheet?
Thanks
Newbi
 
You can use Conditional Formatting from the Format menu to do
this. First select the cell whose color you want to change. Then
open the Conditional Formatting dialog. There, change "Cell
Value Is" to "Formula Is" and enter a formula like

=Sheet1!A1=123

where this refers to the cell whose value you want to change.
Change the 123 to value for which you want to test. Finally,
click the Format button and select the cell format you want to
apply.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
I received an error message as follow:

"You may not use references to other worksheets or workbooks fo
Conditional Formating criteria"

Should the Cell I want to change be where I start the formating?

Sorry,
Newbi
 
You can use a defined name to get around this limitation. Assign
a name to the cell you want to reference in the conditional
formatting formula, and use that name in the formula.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top