| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help please
You're welcome. Thanks for the feedback.
"Chuck H." wrote: Thanks JMB! I found how to do it through the Conditional Formatting as you said. Best regards, "JMB" wrote: =IF(EXACT(B(n), "Y"), C(n)&E(n), "") Also, check out conditional formatting. "Chuck H." wrote: I have a worksheet in which in Column A(n) I want to insert automatically a formula depending on whether one enter in column B(n) a "Y" or a "y". This formula in Column A will contain: =IF(B(n)="Y", C(n)&E(n)) then highlight in green the column A(n). Can this be done? Appreciate your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
