Assign Color to a Cell based on another Cell on a diff Sheet

V

VROSARIO7

Hi,

I am having trouble with the following:

What I want to be able to do is change the color of cell B1 on sheet 2 once
the data on cell A1 sheet 1 is entered.

So if I entered 100% in A1 sheet 1, i want the color of B1 sheet 2 (which
also says 100%) to automatically change.

Is this possible?
 
F

FSt1

hi
yes. in cell B1, sheet2 enter =sheet1!A1
then use conditional formating on cell B1, sheet2.
on the menu bar...format>conditonal format
cell value is....... equal to.......1..............pick you format.

regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top