| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CF to Color-Fill Row B:G w/Specific Text in One of the Cells
Hi All,
I'm in Excel 07 and I have a worksheet which is populated from another worksheet, INDEX-formulas in all cells. Range is B2:G25. Column C gets populated with either M or F. I'm looking for a CF method so that if there's specifically an exact M in row C (not just an M in any word) that the whole row turns a color. The Fs need to do it too but change a different color and I'm guessing I'd just use the same formula but have it look for Fs and change the Fill color, right? Can someone please help me out with a formula for that? Please. Thanks in advance! --Dax -- I would give my left hand to be ambidextrous! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting cells with a specific fill color | Excel Discussion (Misc queries) | |||
| Remove fill color for cells without text only | Excel Discussion (Misc queries) | |||
| I am trying to color fill a cell based on specific criteria | Excel Discussion (Misc queries) | |||
| Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
| My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel | |||
Threaded Mode
