teach-ict.com logo

THE education site for computer science and ICT

Conditional Formatting

A spreadsheet term

Conditional formatting will alter the appearance of a cell depending on what it contains.

For example you can set up conditional formatting to turn a cell red if the number inside it is less than zero.

Or you may set it to change font colour if it meets some criteria. Very handy for spotting important data such as an unpaid bill or making a loss.

In Excel you will find Conditional Formatting under the 'Format' menu.

Challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: Conditional Formatting

2020-10