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

Hi There, How will highlight the middle cell if top and bottom cells are same in excel with conditional formatting.

i have problem if given values are increased above 100 it will it highlight the color using conditional formatting in excel

I need to help with excel highlight cell based on another cell, to show me if a cell's value is lower than another cell. I need this formula for a whole column.

I have an issue with a spreadsheet as follows : My currently spreadsheet has the following formats ; Col B - D.O.B. which I have formulated Col C to display the age in years of employees. Col E - Years to next Medical based on Col C Data i.e. if Age < 60 '3 Years' > 59 '2 Years' Col F - This column adds 3 Years to Col D i.e 3/11/18 = 3/11/21 ideally I would like Col F to be dependent on the Col E either detail 2Y or 3Y i.e. 2020 or 2021 & also highlight the Cell when the date in Col F 30 Days b4 Due Date in the correct year

I need to apply conditional formatting comparing the number in column D to F, and E to F based on the following (D is a # value for the current month, E is 3 month, and F is 12 month). If D is less than or equal to F, then highlight in gree. If D is greater than a 20% increase from F, then highlight in red. If D is less than or equal to the 20% increase from F AND greater than F, highlight in yellow. Same 3 rules for the value in column E compared to F.

I have two sheets in a workbook. The first sheet has formulas to determine a set price. The second sheet has a column that uses vlookup to display the price from the formula. I have another column on that same sheet with old prices. I want to use conditional formatting to highlight prices that are different, but it seems to highlight everything based off of the formula, even if the prices are the same. How can I get it to compare the values from the formula?

I have a 1 column excel spreadsheet with over 8,000 rows in the column. Using conditional formatting, I have highlighted about 350 cells that are spread out within the column. I would like to select the cell below every highlighted cell and highlight them also. Any ideas are greatly appreciated! thanks!

I have a spreadsheet with a list of dates and non dates in column A In column B I want to color highlight cells (so that they can be overwritten with other text) I want to show in column B 1) dates from column A that are greater than 8 weeks 2) dates from column A that are between 6 and 8 week date 3) dates from column A that are less than and upto 6 weeks.

I want to highlight unique values between two workbooks. I have a list of all poeple who have take a course in one book, and thise that still remain members of the assicuation in another

Conditional Formatting Weekedays in Red and highlight yellow the first 10 days of every month tab C4