| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I do a conditional formatting on a cell that is not the same w
Can I do a conditional formatting on a cell that is not the same where the
conditions are at? Let assume that in my model the cell B10 represent a profit or loss of the project. In cell B12, I have some text and I want it to be displayed in black if the value in cell B10 is positive and the text to be displayed in red if the value in cell B10 is negative. How do I go about formating cell B12 using conditional formatting? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting question (if cell = 0, wrap cell in quotes) | New Users to Excel | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) | |||
![Option Button[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
