How can I format cells with data that meets certain criteria?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to include in an IF or other function, a way to make those
cells that meet your criteria bold or other formatting?

For example, if I want to draw attention to values over 10, can I have a
command that will make bold all cells with values over 10?
 
Select your range
Format>Conditional Formatting>Select Cell Value IS>greater than>10
click on Format button then select Font tab, then Bold.
 
Thank you!

Teethless mama said:
Select your range
Format>Conditional Formatting>Select Cell Value IS>greater than>10
click on Format button then select Font tab, then Bold.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count cells in a table that meet multiple criteria 1
CountIf previous cell formula 0
how to get the median of cells that meet a given criteria in excel 1
Need help with a function 3
Cell format as condition 1
Counting unique text that meets several criteria 10
Count contiguous cells, or count cell clusters 0
can I use the sumif function with cell formatting as the criteria 1

Back
Top