Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
change colors
Have the following formula and if a "p" is inserted, I want the color of the
cell to be green(ok), if "x" red(problem). =IF(C66="","",IF(C66=$B66,"p","x")) I saw this somewhere but can't find. Thanks, L. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
change colors
Look at format|conditional formatting.
"L." wrote: Have the following formula and if a "p" is inserted, I want the color of the cell to be green(ok), if "x" red(problem). =IF(C66="","",IF(C66=$B66,"p","x")) I saw this somewhere but can't find. Thanks, L. -- Dave Peterson |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
change colors
Thanks, that's it.
L. "Dave Peterson" wrote in message ... Look at format|conditional formatting. "L." wrote: Have the following formula and if a "p" is inserted, I want the color of the cell to be green(ok), if "x" red(problem). =IF(C66="","",IF(C66=$B66,"p","x")) I saw this somewhere but can't find. Thanks, L. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the colors of each slice in a pie chart easily? | Charts and Charting in Excel | |||
macro used to change colors | Excel Worksheet Functions | |||
conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
How do I use VBA to change line colors | Charts and Charting in Excel | |||
Is it possible to change colors of cells based on value in cell (. | Excel Worksheet Functions |