Changing the fill color of a cell

  • Thread starter Thread starter cquintero57
  • Start date Start date
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.
 
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
 
Elkar,

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

cquitnero.
 
Back
Top