EXCEL FORMULAS

New Contributor

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

3 Replies

@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.

good morning Hans thank you for that.. hmmmm now i have to work out how to do that - can you help me?

@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)