| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting 1 cell depending on a value of another.
Heres what I have:
I have 1 sheet called TeamData and another sheet called MonthlyGain I want to format cells on MonthlyGain dependent on the values of cells on TeamData. Cells on TeamData are either numbers or blank cells. Heres the 1st cell and what I want it to do. I want MonthlyGain!A7 to, if TeamData!C2="", turn the text to red. I have tried the conditional formatting and setting my own formulae but it doesn't work. Any ideas would be appreciated and thankyou in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formatting of row depending on cell value | New Users to Excel | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Formula Depending On Formatting | Excel Discussion (Misc queries) | |||
| How do I change the color of a cell depending on the result of the function in that cell | Excel Programming | |||
| Conditional formatting depending a range of cell | Excel Worksheet Functions | |||
Threaded Mode
