| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add value to conditionnal formatting
Hi,
Newbie question: I'm creating a Gantt Chart and would like to add the number 1 to each cell that meets the condition. The conditional formatting formula is: =AND(L$56=$D82;L$56<=$E82) ...it makes the cell blue. How can have the number "1" also added in the cell? Thanks. Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditionnal Formatting | Excel Worksheet Functions | |||
| How to program a macro to hide rows with conditionnal formating | Excel Discussion (Misc queries) | |||
| Conditionnal formatting using VB | Excel Programming | |||
| Conditionnal formatting using VB | Excel Programming | |||
| Formula... conditionnal format | Excel Programming | |||
Threaded Mode
