Changing the fill color of a cell

C

cquintero57

How do I change the color of a cell based on the value of a cell in another
worksheet in the same workbook? Also, the cell already has a conditional
formating assigned to it based on whether or not it has a value in it before
I check the other worksheet.
 
E

Elkar

To reference a cell on a different worksheet, in Conditional Formatting,
you'll need to give that cell a Name.

From the INSERT Menu, choose "Name", then select "Define"
Type in a Name (for example: MyName)
In the "Refers to:" box, type in the cell reference (or click on the cell)
Click OK

Now, go back to your cell with the Conditional Format
ADD>> a second format
Select "Formula Is:"
Enter the formula: =MyName=100 (or whatever your condition is)
Select your format.
Click OK

That should do it.
HTH,
Elkar
 
C

cquintero57

Elkar,

Thanks for your help, your solution work fine so my problem is solved.

cquitnero.
 
Top