Auto bold a cell

  • Thread starter Thread starter Ernie
  • Start date Start date
E

Ernie

Hi all!

I was told that this was possible in later versions of
Windows and Excel.

Here's what I am looking for:

If A1 on Sheet2 is greater than 0, then A5 on Sheet1 is
bold, else blank.

Is this possible without using VB?

Thanks,
Ern
 
There's Format|Conditional Formatting.

But since your cell to check is on another sheet, you have to give it a nice
range name.

so go to A1 on Sheet2 and Insert|Names|Define. I called mine "mySheet2A1"

Then back to A5 on Sheet1.

format|Conditional formatting
Formula is
=mysheet2a1>0
(with a bold format)

(It's a little easier if the cells to compare are on the same sheet.)
 
Back
Top