Making data highlight in bold - based on a condition

S

saxter

Hi all,

Thanks for other advice previously.

This time I would like to do the following:

I have columns of sales revenue data, I would like the rows tha
contain the clients details (address, # etc) to highlight in bold whe
the sales exceed $30000 in the revenue column.

Would I use Conditional formatting for this?

Thanks in advance for any help

Cheers,

Saxte
 
N

Norman Harker

Hi Saxter!

Select the data table
Format > Conditional format
Formula is:
(Example)
=$E5>30000
Format button
Select format to taste
OK
OK


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top