Questions

Conditional Formatting on worksheets with hidden cells

Tags:
+
0 Votes
Locked

Conditional Formatting on worksheets with hidden cells

carola
I have a user who needs to do conditional formatting on cells that are already created by a formula and also is connected to a VLOOKUP. How can I help her create a conditional formatting for these cells. I've thought about adding another column to do the conditional formatting for that cell and then hiding that column but I keep running into problems with it. I can't seem to write the conditional formatting so it formats another cell other than the one the formula is written in. HELP!!!!!

I trained her in Excel and she's stumping her trainer! :)
  • +
    0 Votes
    cleaverx

    Hello, you will probably have better luck with someone providing a solution, by providing a more detailed explanation of the current environment, also which version of Excel are you using, and exactly what formatting are you attempting to apply?
    Best regards

    The Cleaver

    +
    0 Votes
    carola

    Here's what she has. It's a several sheet workbook and the data she wants to conditionally format is populated in the cells based on pulling it from where the data is actually housed on another page. She has a VLOOKUP formula that also includes pointing it to the original data. The biggest problem is that all over the page where the data she wants to conditionally format there is different kinds of data so I can't just put a formatting based on a full column. Plus it just doesn't want to see the data on that page for some reason. She said it worked very well for her in Excel 2003 but now she's on 2010 and it's not doing it. Does that give you more info? I'll try to address it more if you need more. It has two of us in our IT department here totally stumped.

  • +
    0 Votes
    cleaverx

    Hello, you will probably have better luck with someone providing a solution, by providing a more detailed explanation of the current environment, also which version of Excel are you using, and exactly what formatting are you attempting to apply?
    Best regards

    The Cleaver

    +
    0 Votes
    carola

    Here's what she has. It's a several sheet workbook and the data she wants to conditionally format is populated in the cells based on pulling it from where the data is actually housed on another page. She has a VLOOKUP formula that also includes pointing it to the original data. The biggest problem is that all over the page where the data she wants to conditionally format there is different kinds of data so I can't just put a formatting based on a full column. Plus it just doesn't want to see the data on that page for some reason. She said it worked very well for her in Excel 2003 but now she's on 2010 and it's not doing it. Does that give you more info? I'll try to address it more if you need more. It has two of us in our IT department here totally stumped.