Apr 29 2022 10:39 PM
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
Apr 30 2022 01:36 AM
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.
May 01 2022 03:39 PM
May 02 2022 01:30 AM
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)