Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Cell
Hi,
Is there a way to color a cell with formula, example, In cell "A4" I have the letters "FG" so I need a formula in cell "A5" to look in cell "A4" and see if it = "FG" then color the cell "Yellow" if not then leave as is. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Cell
You cannot do what you ask using formulas on the worksheet, but you can
using Conditional Formatting. Select all the cells you want to have this feature and then click Format/ConditionalFormatting on Excel's menu bar. In the dialog box that appears, select "Cell Value Is" from the first drop down box, select "equal to" from the second drop down box and type ="FG" (that is equal sign, quote mark, FG, quote mark) in the last edit field. Now click the Format button, click on the Patterns tab on the dialog box that appears, and select a yellow color. Finally, OK your way back to the worksheet. If you type FG in any of the cells you originally had selected, the cell should turn yellow in color. Rick wrote in message ... Hi, Is there a way to color a cell with formula, example, In cell "A4" I have the letters "FG" so I need a formula in cell "A5" to look in cell "A4" and see if it = "FG" then color the cell "Yellow" if not then leave as is. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Cell
Select A5 go to Conditional Formatting select new rule, select use a formula
and put this in the box for the formula:- =A4="FG" Then click format fill and select your colour, click OK, next box click OK, next box click apply. Thats it. If the condition is true it will colour, if false it won't do anything. Skinman wrote in message ... Hi, Is there a way to color a cell with formula, example, In cell "A4" I have the letters "FG" so I need a formula in cell "A5" to look in cell "A4" and see if it = "FG" then color the cell "Yellow" if not then leave as is. Thanks. |
Reply |
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 | |||
change fill color of a range of cells based on color of a cell? | Excel Programming | |||
Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
Browse Forms Controls and change TextBox color based on cell color | Excel Programming |