Forum Discussion

Bronwyn1954

Copper Contributor

Apr 30, 2022

EXCEL FORMULAS

Can i ask someone who is clever with Excel - as i thought i was! - can you use BOLD or a COLOUR in a cell as part of a formula? a client asked me this question yesterday and i am not sure. she wa...

Formulas and Functions

HansVogelaar

MVP

Apr 30, 2022

Bronwyn1954

A formula just returns a value, you cannot specify formatting in a formula.

But you can use conditional formatting to highlight a cell depending on the result of the formula in the cell.

Bronwyn1954
Copper Contributor
May 01, 2022
good morning Hans thank you for that.. hmmmm now i have to work out how to do that - can you help me?
- SergeiBaklan
  Diamond Contributor
  May 02, 2022
  Bronwyn1954
  
  I guess you are not going to bold and colour cells randomly, most probably it's some logic behind depends on what formulae return. Formalizing that logic you may apply Use conditional formatting to highlight information (microsoft.com)