Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting help
I need to do a macro with the following condition:
Cell Value contains 'Reject' - Red Cell Value contains 'Accept' - Green Cell Value contains 'Consider' - Orange I need the conditional format on column AA & AB. (But need to exclude Row 1). Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting help
Hi,
go to cell AA2, then press Shift+End+ down arrow, then use conditional formating, Highlight cell where text contains Reject, choose your color, do the same with Accept and consider. Go to column AB and do the same if this helps please click yes thanks "Kim" wrote: I need to do a macro with the following condition: Cell Value contains 'Reject' - Red Cell Value contains 'Accept' - Green Cell Value contains 'Consider' - Orange I need the conditional format on column AA & AB. (But need to exclude Row 1). Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting help
Hi Eduardo,
I know how to set it on Excel but now I need to create a macro for it. Regards, Kim "Eduardo" wrote: Hi, go to cell AA2, then press Shift+End+ down arrow, then use conditional formating, Highlight cell where text contains Reject, choose your color, do the same with Accept and consider. Go to column AB and do the same if this helps please click yes thanks "Kim" wrote: I need to do a macro with the following condition: Cell Value contains 'Reject' - Red Cell Value contains 'Accept' - Green Cell Value contains 'Consider' - Orange I need the conditional format on column AA & AB. (But need to exclude Row 1). Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting help
Use the macro recorder whilst doing the steps.
Gord Dibben MS Excel MVP On Tue, 22 Sep 2009 07:25:02 -0700, Kim wrote: Hi Eduardo, I know how to set it on Excel but now I need to create a macro for it. Regards, Kim "Eduardo" wrote: Hi, go to cell AA2, then press Shift+End+ down arrow, then use conditional formating, Highlight cell where text contains Reject, choose your color, do the same with Accept and consider. Go to column AB and do the same if this helps please click yes thanks "Kim" wrote: I need to do a macro with the following condition: Cell Value contains 'Reject' - Red Cell Value contains 'Accept' - Green Cell Value contains 'Consider' - Orange I need the conditional format on column AA & AB. (But need to exclude Row 1). Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |