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

I need a formula that counts the number of colored cells in a column, regardless of color.

I need a formula that will change the color of the cell when it gets within a certain amount of days to the date in that specific cell. Can you give me an excel formula to change cell color based on date

Cell to change color if the number within exceeds that of the number in another specified cell?

I am trying to format a table to enter the date a certificate is issued and it count down to one year from that date. (I.E. certificate issued on 10/10/2017 I want the conditional format to change the cell color to yellow on 9/10/2018, 30 days prior to expiration, to let me know it is coming due) I can do it if I enter next years date but I need to enter the date the certificate was entered

Utilizing the data provided to you, please construct an Excel Workbook containing the following: Alignment Percentage with Supervisor (must be a working formula) Color coding of Total Count per supervisor teams based on thresholds: Supervisors with <11 employees on Team: Green Supervisors with 12 to 13 employees on Team: Yellow Supervisors with >14 employees on Team: Red A tab containing the following information: A working formula depicting the actual ratio of Representative to Supervisor.

I am trying to do the following using a macro or formula: from this - Column A Column B Row 1 Favorite Color Red Row 2 Favorite Color Blue Row 3 Favorite Color Green to this - Row 1 Favorite Color Row 2 Red Row 3 Favorite Color Row 4 Blue Row 5 Favorite Color Row 6 Green

How do I write a formula based on cel color

Hello, my request is: I have 3 columns (Column A with specific tasks, column B with a category-CAT1 to CAT4- for each task and column C with TODO, IN PROGRESS or DONE). On the other side I have a CAT square (with 4 fields for each CAT). And I would like to display with different color the specific task from column A in CAT field of the square, depending of its Status in column B. In my example, when it's TODO, I would like to keep black color. When it's IN PROGRESS, in yellow. And when it's DONE, in green. See my xls file as example. Could you help me please?

I need a formula that will change the color of an entire row, based on a drop down box selection.

I am trying to get a cell (Group of cells) change back ground color based on what gets input into the column next to it. Basically it's a ticket sheet. If the price has been paid, I want the cell to be green. If it has not been paid, then I would like it to be red. I got the "IF / THEN" Statement to work where it says PAID, or NOT PAID, but I want the color to change as well.