Conditional Formatting

D

Dewayne

Is there a way to conditionally format a cell based on the
value in another cell? i.e.:

If B1=>0,
A1 formats to green or any other chosen format.

Thanks of any suggestions!

Dewayne
 
J

Jason Morin

Sure. Select A1. Format > Conditional Formatting.
Select "Formula Is" on the drop-down and put:

=B1>=0

Click the "Format" radio button and format as desired.

HTH
Jason
Atlanta, GA
 
D

Dewayne

Thanks Jason. Appreciate the help. I actually took an
Excell seminar and they couldn't provide me with the
answer.
Thanks again
Dewayne
 
B

Biff

Hi Dewayne!

That's a very basic operation and they should be teaching
that. If they're not, or, they just didn't know how to do
it, look for a better course!

Biff
 
Top