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