Search : in
By :

Conditional Formatting

Last answer on Aug 27, 2009 1:29:15 pm BST Gaz, on Aug 27, 2009 1:11:51 pm BST 
 Report this message to moderators

Hello,
I am trying to get cells to change colours depending on a number entered. Ideally I would like to use 'Y' or 'N'

If 'A1'=no value entered Then 'B2,.....,B6' does not change
If 'A1'=1 Then 'B2,.....,B6' change to red
If 'A1'=2 Then 'B2,.....,B6' change to green

Configuration: Windows XP
Firefox 3.5.2

Best answers for « Conditional Formatting » in :
Unlimited Conditional Formatting Show Unlimited Conditional Formatting Introduction Principle Code Introduction The limitation of MFC (Conditional Formatting) to Excel version 2007 is less than 3. This is very short. Having seen many applications to push the limit, I am...
Conditional formating - apply on more cells Show
Remove blank cell from conditional formatting Show
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
[VBA] A function that returns the color of an active MFC Show[VBA] A function that returns the color of an active MFC This function returns the value of the active format in conditional formatting. With the function below, two values can be returned. Mode = 0: the value of Interior.ColorIndex...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Download HP USB Disk Storage Format Tool ShowHP USB Disk Storage Format Tool is a small utility allowing to format a key USB or READER MP4. It also allows to make a key (Bootable). This software works with all keys and readers MP4 of the market. To make work this utility under Windows...
Download HDD Low Level Format Tool Show
Download Format Factory ShowFormat Factory is an application that allows conversion of various types of media files. It has various characteristics that allow you to customize a lot of stuff like: Convert video formats, audio and picture shows. Repair damaged files. Reduce...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
MKV format (Matroska Video) ShowMKV format The MKV format (Matroska Video) is an entirely free video format. More precisely, it is a container (hence the name Matroska, in reference to the Russian dolls contained within another) making it possible to contain video (DivX, Xvid,...
Formatting - Formatting a hard drive ShowBefore trying to understand formatting, you first need to understand how a hard drive works. Many people do not distinguish low-level formatting (also called physical formatting) from high-level formatting (also called logical formatting). Even...
Ask your question Reply

1

Qman, on Aug 27, 2009 1:27:34 pm BST

I assume you are using a spreadsheet application.
Depending on your application, there are different ways to do this.
But basically you go to the cell you want to format - in your case B2
Select the option for conditional formatting from the drop menus.
Choose the first format option.
Choose the way the decision will be based.
In this case by FORMULA not Value.
type the formula $A$1=1
then Format what happens when that formula is true by selecting the Pattern, or color the cell is to change to.
Repeat for other formatting options.
Save or Apply.
Copy the formatting to the other cells, or while still on the cell click on the Format Painter (paintbrush) and click-hold-slide across B3-B6 to copy the format.

   
Reply to Qman

2

 Qman, on Aug 27, 2009 1:29:15 pm BST

*If typing $A$1=1 doesn't work, try =$A$1=1

   
Reply to Qman
Ask your question Reply
They need your help