Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
make cell color change if requirements are met?
Is there a way to make a formula that will change the format of a cell if it
meets certain requirements? I.E. Colors, formulas, etc. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
make cell color change if requirements are met?
Look at Format | Conditional Formatting
You can change the fill color, font color and other font characteristics based on the calculated value in the cell. There are also ways to get it to change those based on (hard for me to explain) that cell meeting criteria defined by another formula. But you can't change the formula in a cell based on the results of a formula in that same cell. "PMLACC" wrote: Is there a way to make a formula that will change the format of a cell if it meets certain requirements? I.E. Colors, formulas, etc. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
make cell color change if requirements are met?
As I know, there is no formula to change the cell properties (maybe text() to
change value format, but no cell format); there is one to obtain that: cell(). However, you can change the format of a cell using "Conditional format" (Tools/Conditional format) where you can define up to three diferent formats for the same cell based on the value of the cell vĂ*a core value or a formula. I suggest you to examine that functionality. I hope this helps. Regards. -- Gaspar PM --Adopting methodology-- "PMLACC" wrote: Is there a way to make a formula that will change the format of a cell if it meets certain requirements? I.E. Colors, formulas, etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a null cell as 0 (Zero) so that the subtraction works | Excel Worksheet Functions | |||
How do I make my arrow buttons move from cell to cell in Excel? | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
make a cell empty based on condition | Charts and Charting in Excel |