Get instant live Excel expert help to learn how to change background color based on cell value

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I am using duplicate control in excel through Conditional Formatting, total 18,500 nos. of Rows are existing in the sheet. Filter with Highlight Color is not working now. Please suggest me the best way to check duplicacy..
Solved by O. Y. in 20 mins
For the midterm project you will design and create a workbook. The workbook should help solve some problem or serve a purpose that is of personal value to you, a friend or an associate. Create a short description of the workbook you plan to create as descrbied in Part I of the project. Keep in mind that your workbook must implement the technical requirements described in part II. CS302 Midterm Project Part I: Write a description of the Excell workbook you plan to create. Be sure to choose a project concept that will be of personal use to you, a friend or work associate. Preview your description with your instructor for approvail before proceeding to part II In your description include the following: 1. Who will use the workbook 2. Describe what the workbook will do (What purpose will it serve?) 3. Describe the type of data that will be stored in the workbook 4. Describe some of the analysis and reporting features of the workbook. Midterm Project Part II: Create the workbook to complete your project. Your workbook must implement the following technical requirements. 1. Well formatted with some background color, borders and style 2. Contain at least one database sheet with at least 15 records and 4 fields of data and at least one calculated field. 3. Apply appropriate named cell references to your workbook. 4. Implement goal seek analysis using absolute cell references and an assumption area. 5. Use conditional formatting on the database sheet. 6. Use two or more of the functions from this list: if(), iferror(), sumif(), countif() 7. Use a database lookup function like VLOOKUP() using a lookup table. 8. Create a filter sheet that will demonstrate the use of numberic and text filters applied to your datasheet. 9. Create some scenarios and generate a summary report. 10. Add at least one macro with a button to run the macro. 11. Use solver in some way. Be sure to create an answer report. 12. Add appropriate and consistant data validation fields 13. Create 2 charts of different styles using different data. Include examples of data labels, modify axis settings, legends and titles. 14. Add an imbedded image with a link to a web web site. 15. Add cell and worksheet protection. Highlight the unprotected cells. Make the password "MIDTERM". 16. Be sure to add comments to your project workbook pointing to each of the requirements above. Include the requirement number as the first line in the comment. The comment should point to where you implemented each of the technical requirements. To add comments right click the cell and select the insert comments menu option. 17. Add a sheet to your finished workbook named INDEX. The INDEX will list each of the technical requirements above. The INDEX sheet should be the first sheet in your sheet tab. In the A column of the INDEX sheet create a list titled 1 thru 16 matching up with the 16 technical requirements. Add a hyperlink so that when the instructor clicks on the link it will goto the worksheet and cell containing an example of the technical requirement. In the B column add a short description of your implementation of the technical requirement. This is required for grading purposes. If these hyperlinks are not added to your workbook it will affect your project grade. Submit your description document and project workbook for grading.
Solved by C. J. in 23 mins
Create a new conditional formatting rule that uses a formula to determine which cells to format in the range A4:A57. Apply bold font style and blue font color (eighth column under Standard Colors) to film titles with a rating of PG-13 and a profit of more than $125.
Solved by I. H. in 24 mins
Hello team i have an issue with the conditional formatting, i know it would be simple for you but the problem is i am unable to apply conditional formula to color a cell on acquiring a date that is equal to todays date. The value in the cell is acquired using =X2+28 simple add. Cant i apply a conditional formula on this simple math value using cell ?
Solved by G. C. in 20 mins
Hi I have a cell in excel that i would like to use conditional formatting on. this cell would then look at 2 or more other cells in the same column to see if the value has been duplicated and then change the cell color background to orange or red if the same value is found. thankyou
Solved by T. U. in 28 mins
I’m trying to use conditional formatting to create rules for cells to color code blue or red when values are either lesser or greater. Columns C7-17 and F7-17 are comparing to each other. Columns C24-50 and F24-50 are cells that allow my conditional formatting to work. Ultimately, cells F7-17 are color coded based on comparing to cells C7-17, with the work to allow this formatting following below. Looking at the attached, I need help formatting the cells F8, F10, and F12. Rules I’m struggling on in these three cells: F8: If value is comparing a $ figure to text None, the None cell should be blue. F10: If value is comparing None to $ value, the $ value should be red. If value is comparing % to $ value, $ value should be red.
Solved by I. H. in 13 mins
I have a list of data with 6 digits followed by a dash and two letters (123456-AA) I want a conditional formatting that will color the cell if the first 6 digits match. I know how to use Left(cell #,6) to separate the digits. I also know how to format a regular full match. I just don't know how to combine them.
Solved by S. E. in 30 mins
I need to do a conditional formatting where the first 6 digits are the only consideration and color code any matches in the column. Please help with excel cell color formula.
Solved by K. J. in 25 mins
I need help with a formula of color changing (conditional formatting), can you show me excel formula based on cell color
Solved by Z. W. in 15 mins
I’m working on a project in which I need to have the rows (A to I) to be highlighted in specific color based on the text provided in the particular cell, if it is a single row/cell I’m able to do it thru conditional formatting but it is required it in multiple rows. For Eg. If Cell A1 has the text “Naren” and cell A2 has “B” then the row should be highlighted in Green and the same cells has the text of “Bas” and “C” then the row should be highlighted in red, point to note here is the text will be in multiple rows and in whatever rows/col (cell) it is updated the particular row should be highlighted with specified color.
Solved by S. J. in 29 mins