How to make a formula bold based on imput

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
 
F

Frank Kabel

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top