PDA

View Full Version : CONDITIONAL FORMATING IF CELL HAS ROUND FORMULA



SteveM99
08-15-2018, 11:59 AM
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
08-15-2018, 02:28 PM
See column C conditional formatting in attached.

Paul_Hossler
08-16-2018, 06:12 AM
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
08-17-2018, 06:11 AM
THIS WILL BE SHOUTED....THANK YOU AGAIN P45CAL!!!! I WILL USE THIS IN VBA PROGRAMMING!!!!

SteveM99
08-17-2018, 06:11 AM
Sorry for caps, my eyes were sore that day.

Paul_Hossler
08-17-2018, 07:35 AM
Sorry for caps, my eyes were sore that day.



A loud THANK YOU is always ok :thumb:thumb:thumb:yes:yes:yes