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...

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

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

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