Formatting in a Formula

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

Guest

Does anyone know a way I can add a fill color to a cell if the value exceeds
a threshold (ie an alert)?

Thanks,
 
Hi

Yes, use conditional formatting

click in the cell in question
choose format / conditional formatting
choose
cell value is
choose greater than (or whatever)
enter the value
click on the format button
set the formatting
click Ok, and Ok again

Cheers
JulieD
 

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

Back
Top