If-Then Formula
The answers by Bob and Tom to Phil's question were very clear. They helped me also. Thank You!
An add-on question, if you don't mind... Is there also a way to conditionally change the cell format at the same time as we change the value - such as font and fill color? -- Robert "Phil Hageman" wrote: This is a re-post of a previous request, explained differently - I need a single formula to do the following: Variables is the name of a worksheet This formula is located in another worksheet named Scorecard If Variables!C12=€ťA1€ť, then populate cell with Variables!D53 If Variables!C12=€ťA2€ť, then populate cell with Variables!D54 If Variables!C12=€ťA3€ť, then populate cell with Variables!D55 If Variables!C12 is blank, then populate cell with blank. |
If-Then Formula
I'll only answer the one<vbg.
You can apply conditional formatting to the cells (FormatConditional Formatting), and here you can test the value and set both attributes that you mention. Only 3 values though. -- HTH ------- Bob Phillips "Robert" wrote in message ... The answers by Bob and Tom to Phil's question were very clear. They helped me also. Thank You! An add-on question, if you don't mind... Is there also a way to conditionally change the cell format at the same time as we change the value - such as font and fill color? -- Robert "Phil Hageman" wrote: This is a re-post of a previous request, explained differently - I need a single formula to do the following: Variables is the name of a worksheet This formula is located in another worksheet named Scorecard If Variables!C12="A1", then populate cell with Variables!D53 If Variables!C12="A2", then populate cell with Variables!D54 If Variables!C12="A3", then populate cell with Variables!D55 If Variables!C12 is blank, then populate cell with blank. |
All times are GMT +1. The time now is 12:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com