cell value recognition

D

daniel@hawaii

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
 
B

Biff

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

"daniel@hawaii" <[email protected]>
wrote in message
news:[email protected]...
 
Top