asked on Excel Conditional Formatting - format group of cells based on formula with not static formula
I'd like to conditionally format a range of cells to highlight a color if the cell does NOT have a formula (let's me know if a user has keyed over it). I can do this for a cell using a formula, but the formula references a specific cell so I'd have to do this for all cells in question. I need of version of this that applies itself to whatever cell is being evaluated. I'm open to a different formula as well. This was simply one way to get there.
![Sample where a specific cell is referenced]()
Microsoft ExcelMicrosoft ApplicationsMicrosoft Office
Last Comment
Ray
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Wow, plenty of good information.
Rob - Exactly what I was looking to figure out
Krompton - I don't care if they do change them as it is sometime necessary, I just need to know IF they did.
Saurabh - Being the long time expert you are, I appreciate the way you covered all the bases with your solution.
QUESTION on this, if I use the ISFORMULA in a conditional format and someone open in Excel 2010 or earlier, will it cause a problem or simply not apply the formatting? If no error, then I don't really care if others see the formatting change as long as I do :-)
Rob - Exactly what I was looking to figure out
Krompton - I don't care if they do change them as it is sometime necessary, I just need to know IF they did.
Saurabh - Being the long time expert you are, I appreciate the way you covered all the bases with your solution.
QUESTION on this, if I use the ISFORMULA in a conditional format and someone open in Excel 2010 or earlier, will it cause a problem or simply not apply the formatting? If no error, then I don't really care if others see the formatting change as long as I do :-)
If the person open this in excel 2010 the conditional formatting won't be applied once the calculation is triggered since this formula in not their in 2010 it will give a #Name error as a result your formatting won't be applied...
Just tested the same as well since i have both versions of excel in this pc..The conditional formatting gets applied in 2013 only...
Just tested the same as well since i have both versions of excel in this pc..The conditional formatting gets applied in 2013 only...
ASKER
Rob's solution was the EXACT thing I was looking for and covered my concerns on this specific issue.
Split points because Saurabh's solution was insightful and could've been THE solution under other circumstances.
Split points because Saurabh's solution was insightful and could've been THE solution under other circumstances.
Krompton