CONDITIONAL FORMATING IF CELL HAS ROUND FORMULA

[SteveM99]

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.

[p45cal]

See column C conditional formatting in attached.

[Paul_Hossler]

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.

IT'S NOT REALLY NECESSARY TO SHOUT IN THE TITLE AND THE MESSAGE

It makes it harder to read and it might be misinterpreted

[SteveM99]

THIS WILL BE SHOUTED....THANK YOU AGAIN P45CAL!!!! I WILL USE THIS IN VBA PROGRAMMING!!!!

[SteveM99]

Sorry for caps, my eyes were sore that day.

[Paul_Hossler]

Sorry for caps, my eyes were sore that day.

A loud THANK YOU is always ok