| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another 'IF cell contains THEN color row' Question
I have been researching this for hours. I have a large spreadsheet
that I want to apply a conditional formatting scheme where if any cell in column AC contains 'FMRR' then color that row green. If the cell in AC does not contain FMRR then do nothing. The operator 'CONTAINS' does not exist in conditional formatting, therefore I cannot see how I can use it. The FMRR numbers contain numbers aswell. For example 'FMRR-01234' therefore I need to query on contains 'FMRR'. Any advise? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Another 'IF cell contains THEN color row' Question
In Conditional Formatting, use Formula Is =FIND("FMRR",$AC1)
-- David Biddulph "BeatonD" wrote in message ps.com... I have been researching this for hours. I have a large spreadsheet that I want to apply a conditional formatting scheme where if any cell in column AC contains 'FMRR' then color that row green. If the cell in AC does not contain FMRR then do nothing. The operator 'CONTAINS' does not exist in conditional formatting, therefore I cannot see how I can use it. The FMRR numbers contain numbers aswell. For example 'FMRR-01234' therefore I need to query on contains 'FMRR'. Any advise? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell format question | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Answering a question in a cell | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Linear Mode
