Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |