Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 25th 06, 04:49 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 3
Default Multiple conditions for conditional formatting

Can I have more than 3 conditions for multiple formatting? If so, can anyone
tell me how? I have 4 potential text phrases to choose from a drop-down list
and would like each to be coloured appropriately

Many thanks.
P.

  #2   Report Post  
Old September 25th 06, 05:05 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 751
Default Multiple conditions for conditional formatting

P.,
if it is only 4 then you can use the cell's standard format for one of
the phrases and conditional formatting for the remaining three.

If this does not help then you will need VBA. A Worksheet_Change macro,
which will automatically apply the format if the cell changes. For a
full code write back if the suggestion does not suit you, with the
formatting changes you want in each of the 4 cases.

HTH
Kostis Vezerides

  #3   Report Post  
Old September 25th 06, 05:07 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,047
Default Multiple conditions for conditional formatting

Hi,

here a tip to have 6 without macro, more than it just with a vb code
http://mcgimpsey.com/excel/conditional6.html

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"plf100" escreveu:

Can I have more than 3 conditions for multiple formatting? If so, can anyone
tell me how? I have 4 potential text phrases to choose from a drop-down list
and would like each to be coloured appropriately

Many thanks.
P.

  #4   Report Post  
Old September 27th 06, 10:55 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 3
Default Multiple conditions for conditional formatting

Hi Marcelo,

Thanks for this. However, I cant work out how to make it work using text
phrases instead of a list of numbers. Any ideas?

P.

"Marcelo" wrote:

Hi,

here a tip to have 6 without macro, more than it just with a vb code
http://mcgimpsey.com/excel/conditional6.html

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"plf100" escreveu:

Can I have more than 3 conditions for multiple formatting? If so, can anyone
tell me how? I have 4 potential text phrases to choose from a drop-down list
and would like each to be coloured appropriately

Many thanks.
P.

  #5   Report Post  
Old September 27th 06, 11:00 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 3
Default Multiple conditions for conditional formatting

Hi Kostis,

Thanks for your reply. I'm not much use with macros so would be happy for
your help. I'd like to have the following four conditions:

1. If the cell says "Dev, on" then the background should be e.g. green
2. If the cell says "Dev, off" then the background should be e.g. blue
3. If the cell says "Imp, on" then the background should be e.g. yellow
4. If the cell says "Imp, off" then the background should be e.g. red.

Many thanks for any help.
P.

"vezerid" wrote:

P.,
if it is only 4 then you can use the cell's standard format for one of
the phrases and conditional formatting for the remaining three.

If this does not help then you will need VBA. A Worksheet_Change macro,
which will automatically apply the format if the cell changes. For a
full code write back if the suggestion does not suit you, with the
formatting changes you want in each of the 4 cases.

HTH
Kostis Vezerides




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting should allow more than three conditions. Joshua, Technical Editor Excel Discussion (Misc queries) 1 July 26th 06 12:44 PM
How do I add multiple values that match multiple conditions? Joel Excel Discussion (Misc queries) 5 April 10th 06 01:32 PM
Need more than 2 conditions in Conditional Formatting Amy Excel Worksheet Functions 6 March 9th 06 06:25 PM
I have more than 6 conditions when using conditional formatting? Magda Excel Worksheet Functions 3 March 1st 06 09:15 AM
Conditional formatting capability for 20+ conditions not just 3. Charles Smittenaar Excel Discussion (Misc queries) 2 October 28th 05 11:30 PM


All times are GMT +1. The time now is 01:59 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017