update conditional formating in shim