| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Quote:
If u r using Office 2007 onwards use the conditional format Select conditional format Select new rule Select use a formula to determine which cell to format then in the formula bar just as example Cell d4 is selected in the formula bar click on cell c4<0 format fill red color Thanks may this help Bakar |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Conditional Formatting to Conventional Formatting | Excel Programming | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Hybrid Mode
