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.

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


"cquintero57" wrote:

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.

Elkar,

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

cquitnero.


"Elkar" wrote:

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


"cquintero57" wrote:

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.