Colouring cells

Mar 4th, 2002, 08:34 AM

How can I colour a cell with a different colour depending on the value selected from a drop down box?

sax · Mar 4th, 2002, 09:00 AM

Hi,
You can use Conditional Formatting.
"Format"-"Conditional Formmating"
Put Cell value to be the one from drop down list, and in Format go to patterns and select colour.
The bad thing is that you can have only three conditions, meaning that you can have only three different numbers from drop down list.
Myybe someone can help you with some VBA formula.
Sax

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 08:34 AM	#1
Guest Posts: n/a	How can I colour a cell with a different colour depending on the value selected from a drop down box?

Mar 4th, 2002, 09:00 AM	#2
sax Board Regular Join Date: Feb 2002 Location: Belgrade, Yugoslavia Posts: 148	Hi, You can use Conditional Formatting. "Format"-"Conditional Formmating" Put Cell value to be the one from drop down list, and in Format go to patterns and select colour. The bad thing is that you can have only three conditions, meaning that you can have only three different numbers from drop down list. Myybe someone can help you with some VBA formula. Sax