Exce adv

Resolved · Low Priority · Version 2003

Tue 20 May 2008, 10:15 Delegate Rebecca said...

Rebecca has attended:
Excel Advanced course

Exce adv

How do you change the coclur of a cell if a statement is true/false
eg. Answer=No then cell=red
=yes then cell=green

Fri 23 May 2008, 15:24 Trainer Amanda said...

RE: Exce adv

Hi Rebecca

Thank you for your question; and welcome to the forum.

You can get Excel to apply formatting based on what is contained within a cell by using Conditional Formatting.

This is found under the Format menu - Format/Conditional Formatting.

If you wish to set more than one criteria for the cells you have selected, then click the Add button once you have put your first criteria in place.

You can have up to 3 different criteria for the same group of cells.

I hope this helps.
Amanda

Excel tip:

Using an equal (=) sign that isn't part of a formula

Before you type the equal sign, type an apostrophe: '
Then type your equal sign: = (and anything else you want to add after your equal sign)
Press ENTER.

(the apostraphe will disappear

View all Excel hints and tips

Exce adv

Exce adv

RE: Exce adv

Excel articles

Excel tip:

Using an equal (=) sign that isn't part of a formula