Changing cell format based on cell content

P

Paul Moles

You need to use conditional formatting,found on the format
menu. Has three potential conditions each additional
condition accessed by the Add button at bottom of
conditional formatting box. You can change either the
font, the font colour, the border,the colour and pattern,
for each condition. Note once one condition is met the
next are subsequently ignored so think about their order.

HTH

Paul
 

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

Top