Ask Your Question

Conditionally format cells containing formulae?

asked 2016-01-14 14:23:51 +0200

chimak111 gravatar image

Is it possible to format only cells that contain formulae?

edit retag flag offensive close merge delete


Green color on Ctrl+F8?

JohnSUN gravatar imageJohnSUN ( 2016-01-14 14:52:51 +0200 )edit

That colors all cells containing dates and numbers, whether the numbers are directly entered or as a result of formulas. I want only the cells containing any formulas to be differently formatted.

chimak111 gravatar imagechimak111 ( 2016-01-14 16:59:12 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2016-01-14 17:29:38 +0200

JohnSUN gravatar image

OK, try so: Formula is ISFORMULA(<cell_address>) no description

edit flag offensive delete link more


Perfect, thank you :)

chimak111 gravatar imagechimak111 ( 2016-01-14 17:45:44 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-01-14 14:23:51 +0200

Seen: 52 times

Last updated: Jan 14 '16