exce adv

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Exce adv

Exce adv

resolvedResolved · Low Priority · Version 2003

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

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


Server loaded in 0.08 secs.