Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 25th 05, 03:16 PM posted to microsoft.public.excel.worksheet.functions
Mon
 
Posts: n/a
Default Conditional Formatting

Don't know if this is possible:
I have a report where column A has a drop down list of 6 choices. Rows D:I
are conditioned upon which choice is picked in A. For instance, if the
choice "Flight" is chosen in A, then I want C,D,E & I to be highlighted,
while F,G, and H are greyed out. This then takes out 1 of the 3 conditions.
Is there a way to include more than just the word "Flight" when I want
something highlighted or grayed out?
Here is the Condition that I have: =$A$7="Flight" (for columns C,D,E & I)
then to highlight green -- but in some of the other choices in Column A that
I have it also works to have C,D,E & I highlighted. Can I add to "Flight" in
my function? Something like: =$A$7="Flight""Mileage"
Hope this makes sense...


  #2   Report Post  
Old November 25th 05, 03:32 PM posted to microsoft.public.excel.worksheet.functions
SteveG
 
Posts: n/a
Default Conditional Formatting


Mon,

In the Formula Is:

=OR($A$2="Flight",$A$2="Mileage")

Regards,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=488175

  #3   Report Post  
Old November 25th 05, 04:23 PM posted to microsoft.public.excel.worksheet.functions
Mon
 
Posts: n/a
Default Conditional Formatting

AWESOME! Thank you so much!!

"SteveG" wrote:


Mon,

In the Formula Is:

=OR($A$2="Flight",$A$2="Mileage")

Regards,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=488175


  #4   Report Post  
Old November 25th 05, 04:37 PM posted to microsoft.public.excel.worksheet.functions
SteveG
 
Posts: n/a
Default Conditional Formatting


Anytime.

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=488175



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 Error ddate Excel Worksheet Functions 0 May 5th 05 09:00 PM
difficulty with conditional formatting Deb Excel Discussion (Misc queries) 0 March 23rd 05 06:13 PM
conditional formatting question Deb Excel Discussion (Misc queries) 0 March 23rd 05 02:07 AM
Determine cells that drive conditional formatting? Nicolle K. Excel Discussion (Misc queries) 2 January 7th 05 01:08 AM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM


All times are GMT +1. The time now is 02:40 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017