I AM TRYING TO APPLY CONDITIONAL FORMATING IN AN EXCEL MACRO TO PROGRAM RANGE TO COLOR THE CELLS IF THEY CONTAIN THE ROUND FORMULA. WE HAVE FORMULA IN THE CELLS WHICH ROUNDS THE USERS ESTIMATES. THE USER MAY OVERRIDE THE ROUND FORMULA BY HARD CODING A PRECISE DOLLAR AMOUNT IF THEY DECIDE TO. WHEN THEY DO THE ROUND FORMULA IS OBVIOUSLY GONE. I CANNOT USE THE ISFORMULA FUNCTION AS THE USERS MAY HARD CODE THE CELLS WITH FORMULAS OTHER THAN ROUND, FOR EXAMPLE +60000/12. IS THERE A WAY TO APPLY CONDITIONAL FORMATING TO CELLS IF THEY CONTAIN THE ROUND FORMULA GIVEN THESE PARAMETERS.


PS. I WOULD RATHER NOT USE HELPER CELLS AND USE A COMBO OF ISFORMULATEXT AND COUNTIF.