Get instant live Excel expert help to learn how to color in excel cell

I need a VBA Code that sorts a table by 2 conditions. The first being G3:G252 by a single cell color at the top, the second being an ascending numerical value in the rang A3:A252. I want a VBA code, because this is dynamic data that will be altered.

How to Use Conditional Formatting to Change Cell Background Color Based on Cell Value not for only 1 cell but all the cells depending upon the cell value entered. for example I have four status as 1 )open 2) Resolved 3) Overdue 4) hold. I want the cell should change color as green if resolved and red as overdue and open as brown and hold as yellow.

I have a spreadsheet with 2 tabs. I need to compare the tabs and color code them. The data consists of bar codes. Sheet A has one long list of inventory. Sheet B consists of bar codes scanned into the file. The bar codes located on both tabs should be highlighted yellow on both tabs. The bar codes that are only located on one of the 2 tabs should be highlighted red on the sheet that they appear on.

I have a spreadsheet with 2 tabs that need to be compared. The data consists of bar codes. I need the two tabs to be color coded. If a bar code is on both sheets it should be highlighted yellow. If a bar code is only located on one of the sheets then it should be highlighted red.

One excel file with 2 tabs that need to be compared and color coded. Over 13,000 line items.

I need to merge, compare, and color code 2 large files.

I need a set of functions that will color my calendar for work shifts, according to a rolling schedule; 5 on, 2 off, 5 on, 3 off. It restarts whenever there's any deviation in the shift, so I need the option to change the start dates.

. I have a spreadsheet that tracks the number of each one's Projects, and the percentage of those projects that have been completed. I have set up conditional formatting using the built in: "Format only cells that contain" and by using: "Between" and "Less Than" rules, that change color (Red, Yellow, Green), according to the percentages complete, as the year progresses and it is working perfectly. My objective is for the colors to change each month as the year progresses. I have formulas, (based on "Today" date), in cells under each month's column, that turns from "False" to "True" automatically, when we arrive at that month, Ideas?

How do I display dates on x-axis which I have selected from date picker? What should I do to automatically set min x-axis value after entering new data in the table? How do I apply the condition for the color changing of bar according to the different conditions?

I need a chart to be created smae as this on the picture. the color does not matter but yellow on black looks great. whihc chart shouldI take and how I could creatte this one?