Conditional formatting based on formula

Question

Is there a way to change the text or background color of the cell if that cell contains formula? Ideally I'd like to change text to blue if cell is referencing other cells (similarly to HTML where links are in different color).

Thanks a ton! For some reason, this link doesn't have ISFORMULA so i've missed it. — Adam Bienias
– Adam Bienias, Commented Nov 12, 2017 at 16:04

QHarr · Accepted Answer · 2017-11-12 16:15:32Z

1

You can add conditional formatting rules for this:

Conditional Formatting -> use a formula to determine which cells to format

Then add either:

=ISFORMULA(A1)

or

=LEFT(FORMULATEXT(A1),1) = "="

And apply to whichever range you want. Make sure A1 is not entered as $A$1.

You would then set the font to blue associated with the rule or the fill.

There are probably other ways as well.

edited Nov 12, 2017 at 16:15

answered Nov 12, 2017 at 16:05

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Conditional formatting based on formula

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related