Conditional Formatting

[Mon]

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

[SteveG]

Mon,

In the Formula Is:

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

Regards,

Steve

[Mon]

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

[SteveG]

Anytime.

Steve