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

i need different color for Underweight Healthy weight Overweight Obese Morbidly obese

Columns A and E need to be checked against each other. If the name appears in both list, it should be highlighted. Column B and Column E need to be checked against each other. But first, the zero needs to be removed behind each field in Column B. If Column E and Column B has a number that appear in each list. It should be hightlighted in another color.

Hello, I want to change the font color for lines that have been updated. If a new position or new step is entered, the font colour of the entire row should be changed in orange. Column E > conditional formatting > manage rules > New rule > Use a formula to determine which cells to format Formula =IF(NOT(ISBLANK($E2)),TRUE) Format = Bold orange color Applies to : =$A$2:$F$2 How to replicate it to the following rows? The formula does replicate but not the Applies to For row 3 I should get Formula =IF(NOT(ISBLANK($E3)),TRUE) Format = Bold orange color Applies to : =$A$3:$F$3 Thank you

Can you hide a single cell to prevent it from printing? I can't just hide a row or column, I need to be able to print an entire sheet but hide the content of a single cell in the middle of it in the printed form but still be able to view it while working on it (so changing the font color to white to hide it is not the answer I'm looking for).

I have a conditional format that is color filled for favorable 10>8, unfavorable 5<9, and no change for 6=6, I would like to add text to the rules in the cell.

Hello. I have a table with numbers from 1-100. I want to highlight the multiples 7 for instance.. I am able to use the conditional format for one cell ie if =mod($A$1,7)=0 the fill with a color eg yellow. I am not able to use the format painter to copy this to the whole table in a meaningful way. So I would like the painted format in A5 to be =mod($A$5,7)=0 so the effect of the formatting is due to its own value not of the cell it was copied from ie mod($A$1,7)=0. I could do each cell individually, but that would be cumbersome. I assume there is a better way. Thanks in advance. Alok .

I need to pout conditional formatting for a scenario where if the cell value is positive then green and red if the cell value is negative, however, i also need to give refernce to other cell where another value basis which i need to validate before giving the cell a red color

I want to color the cells background based on a value of the cell beforeFor example: B3 cell background colored is based on the value on B2 cell if it less than or greater than I want to choose a color for that

i hace a spreadsheet that one cell has to equal another cell, but i need the cell to be colored when nothing returns and no color when the cell returns something.

In the Due Date section I need a formula that shows once the completion date has been entered it is no longer passed due and is no longer showing up as color red