Conditional Formatting

[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

 

[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

 

[Dewayne]

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

 

[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