Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CF help needed with cell color
I have the following two formulas for the same area the first works the
second does not. =C$5<ROW()-5 =C$6:$I$14="MCR" The first one places a color in a group of cells unless a drop down menu gives it a different number of cells to cover. What i want the 2nd to do, is to have in that same grouping of cells, change the color of the font to red if the letters MCR are in that cell. What did i do wrong in my formula. Thanks for your help. Neal. -- NealMed |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
Event Macro adjustment needed - need to change font color also | Excel Worksheet Functions | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) |