Making data highlight in bold - based on a condition

  • Thread starter Thread starter saxter
  • Start date Start date
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
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top