Link to home
Start Free TrialLog in
Avatar of Julian Solano
Julian SolanoFlag for Costa Rica

asked on

MS Excel Cell questions

Hello, my issue is that i have a sheet full of formulas that give different values and we need to make the cells with formulas have the values and not the formulas because the conditional formatting and the VBA Code we are using is not recognizing the cell value as the result, it is recognized as a formula and is formatting wrong.
Avatar of Norie
Norie

Conditional formatting will not distinguish between a value that's a result of a formula or is hard-coded.

Can you attach a sample workbook?
Avatar of Julian Solano

ASKER

I have attached the file I need to do the formatting for the date of birth that is on the file.
Thanks for the help.
Auditing-Tool.xlsm
ASKER CERTIFIED SOLUTION
Avatar of Tim Berry
Tim Berry

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Trying to send back your sheet here...
Auditing-Tool.xlsm
AWESOME! Thanks you fixed the issue I was having!