How to make a formula bold based on imput

  • Thread starter Thread starter greenfalcon
  • Start date Start date
G

greenfalcon

Hi i need some help, if anyone knows how to do this the help would b
greatly appriciated.

I have some formulas and need some help with/without conditiona
formatting.

Part 1 of the equation is Red
Part 2 is Green

if A1 <= 5
Then A1-A2 = Result
if Result >1.0 Then print result in bold
If 5 < A1
Then
A1-A2 = Result
If Result > (.20)(A1) Then print result in bold.

is it possible to do this, what im trying to say is that if the firs
part of the equation

is true, and it is above 1. then print it in bold and ignore the bol
statment for part 2 of the equation.

If part 1 is false
then ignore that bolding statement and only check part 2 of th
equation if that is true, if so bold.

Thanks.

Jaso
 
Hi
have you checked 'Format - Conditional Format).
In A3 enter:
=A1-A2

and then just enter your conditions in the con ditional format dialog
 
Back
Top