need help with conditional formula

  • Thread starter Thread starter chris
  • Start date Start date
C

chris

Hi- need help.
How do I format the following?
I want cell 1 to be one of three colors
depending on the value in cell 2 being 1,2,of 3?
Much obliged.
(e-mail address removed)
 
select the cell (assume it's A1 you want to colour and A2 with the values,
do format conditional formatting, formula is

=$A$1=1

click format>patterns and select colour 1, click add and use

=$A$1=2

repeat..
 
It's called conditional formatting. It can be found in the
Help or by using it -- Format->Conditional Formatting.

You can set up to three conditions per conditional format.
For example, Condition 1 you'd choose "Cell Value Is"
"equal to" and then the cell2 reference. Click the format
button and select a color.

Excel Support Technician
www.canhelpyou.com
 
Back
Top