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! 🙂