cell value recognition

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

daniel@hawaii - 12 Jul 2006 05:01 GMT

newbie here:)
I would like to have a cell recognize if its formulated value is larger
than another cell's formulated value. And if it is, make text bold.

any help is appreciated,
mahalo,
danny

Signature

daniel@hawaii

Reply to this Message

Biff - 12 Jul 2006 06:13 GMT

Hi!

Suppose you want to bold cell A1 if the number in cell A1 is greater than
the number in cell B1.

Do this:

Select cell A1
Goto the menu Format>Conditional Formatting
From the drop down select Formula Is
Enter this formula in the little box to the right:

=AND(COUNT(A1:B1)=2,A1>B1)

Click the Format button
Select the Font tab
Select Bold
OK your way out

Biff

> newbie here:)
> I would like to have a cell recognize if its formulated value is larger
[quoted text clipped - 3 lines]
> mahalo,
> danny

Reply to this Message

Rate this thread: