Get instant live Excel expert help to learn how to highlight a cell in Excel

Excel 2010, Conditional formatting ISFORMULA(A2) highlight I would like all my cells that have formulas in their cell to be highlighted. I read the above formula online and applied it to my worksheet, and no highlights on the worksheet at all?? So, I used the exact example online then applied the conditional format above rule and again no highlights. What would prohibit the highlights? Is there another way to get the results I am looking for?

I have two sheets of data. I need to run a check for inconsistencies between the two sheets and highlight the rows in sheet A where the data does not match.

how to calaute remaining days after manually enter 6 month leave , i need to highlight before one month

adding my own table so it will automatically highlight all values that match in the peoples columns

1) I'm trying to use conditional formatting to highlight the lowest value in column D if the value in column C = "yes" and only if there are no other instances of that value. For example, if the lowest value in column D is 3 and the value in column C = yes but there is another instance of a 3 in column D and a "yes" in column C, then no cells should be highlighted. I have a conditional formatting formula built that is highlighting the lowest value in column D but doesn't take into account that the value in column C must = "yes". 2) If step 1 above is possible, can the conditional format formula in column D then be copied to column E?

Hi..I just want to highlight non ascending number in a list using macro

I need cell to highlight red after 90 days of the start date of fining. the problem is, start date is not defined until manually entered, so "TODAY" is not working.

I am working on my budget sheet... I have a column A that has due date Column B amount due Column C amount paid I want to do a conditional formatting to highlight cells that are less than today ( <Today() ) AND when Amount paid < amount due

the Data worksheet: a. Create an Excel table with the recently imported data. b. Pick a style with the styles group to format the table (choose a style that shows banded rows, i.e., rows that alternate between 2 colors). c. The style must highlight the field names in the first row. These are your table headers. d. Ensure NO blank cells are part of the specified data range. e. Ensure that Header Row and Banded Rows are selected in the Table Style Options Group Box. Do NOT check the Total Row.

I have created an Excel table. There are 149 rows so far. When I highlight everything and select sort and filter to alphabetize it only alphabetizes the first 50 rows. The first 50 rows are alternating blue and white. The rows after 50 are not alternating colors. How can I alphabetize all 149 rows (I'll be adding more)?