Find solution
How to change input value in formly?

Microsoft Excel: How can I change the background colour of a cell as soon as its value is changed?

  • I am providing a yellow background for all the cell in which user input is required. But as soon as user input's the value, I want the background colour to change back to automatic.

  • Answer:

    As Derek mentioned, Conditional Formatting is the answer. Select the cells you want to have this yellow formatting applied. Click on Home=>Conditional Formatting=>New Rule Click on "Format only cells that contain" in the Rule Type box In the first drop-down menu after the "Format only cells with:" prompt near the bottom of the window, select "Blanks" Click on the Format button at the bottom and select the Fill tab Select the yellow fill color Now all the cells you have selected in Step 1 that do not have values in them will default to the yellow background you selected in Step 6. If you are also looking to speed up your productivity in Excel, my company has developed an Excel keyboard overlay that fits on tops of Macbooks with the most common keyboard shortcuts printed on the overlay. You can learn more at: http://www.thekeycuts.com/shop/keyboard-covers.

Al Chen at Quora Visit the source

Was this solution helpful to you?

Other answers

The feature you are looking for is called Conditional Formatting. This should lead you in the right direction: http://office.microsoft.com/en-us/excel-help/quick-start-apply-conditional-formatting-HA010370614.aspx

Derek Steer

In a Financial Model, cells requiring User Inputs, Conditional Formatting can be used to highlight unfilled and filled cells. Lets say you have a simple model requiring 3 inputs - Price, Volume and Growth in Vol. The template of the model would look something like: From the model template, select the input cell that you want formatted (In this case, Price for FY12) Now go to Custom Formatting and add the rule, which says - If it is blank format it as yellow, else do not format at all (or an alternate format) Now Copy the format and paste the format on the other input cells Now if you populate the model, it would automatically format itself If you wanted an alternate format for the filled input cells, you can to go conditional formatting --> manage rules Add a new Rule, which just says if the cell is not blank, then give an alternate format

Paramdeep Singh

It is by using Conditional Formatting. Check out the Weblink/ Slideshare below to learn about Conditional Formatting.http://sathyawrites.com/learn-ms-excel-conditional-formatting/

Sathyanand Swami

The desired result can be achieved by using Conditional Formatting. Follow the below given steps:- Select the cells in which the desired effect is required on entering any value Select the Conditional Formatting and then New rule from the drop down menu as shown below 3. In the New Formatting Rule dialog box select the Format only cells that contain option and select the Blanks option under the Format only cells with. Now click the Format and select the yellow color from the Format Cells dialog box and click OK 4. The rule will be activated in the selected cells and can be spread to other cells of your choice by using Format Painter.Hope this solves your purpose. For more detailed tutorial you can refer http://www.excelfunda.com/how-to-change-background-color-in-excel-based-on-cell-value/

Aman Saini

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.