Get instant live Excel expert help with conditional formatting

Business Spread sheet. Need Help The CEO has asked you use conditional formatting to create an easy visual on the spreadsheet of any device that is near the end of its useful life. Utilize conditional formatting for all columns that contain a depreciated value of less than $500 they will appear red. Create a pie chart to show the initial cost totals by department. You may create a set of summary data to the right of the current data to use for the creation of your chart.

I have a list of services for various sites within our business, some of these services are the same at different sites but have different costs. I am looking for the best way to show which services have variant costs and what they are. I have tried a range of Nested IF formula's and some basic conditional formatting but it becomes over complicated. Any assistance on how best to present this would be appreciated

I'm trying to use conditional formatting for two separate columns and it doesn't seem to work.

need help with conditional formatting please do not answer if you cant faced bad experience earlier here.

I am trying to create a conditional formatting rule. I need to have this rule to bold specific cells that contain a few different text. (IE Apple, Pear, Banana)

I have 2 excel spreadsheets, A and B. In file B I include 2 columns which are linked to file A in order to retrieve data. I want to make sure that when data is updated in file A, the cells in file B are highlighted. Is there a conditional formatting rule I could set up?

i need to run conditional formatting on a cell, but i need the type of conditional formatting to depend on the date in another cell, is this possible?

need help with conditional formatting which gets changed everytime i enter new data one expert was not able to solve that i think name was manish or something

I have a list of data with 6 digits followed by a dash and two letters (123456-AA) I want a conditional formatting that will color the cell if the first 6 digits match. I know how to use Left(cell #,6) to separate the digits. I also know how to format a regular full match. I just don't know how to combine them.

I need to do a conditional formatting where the first 6 digits are the only consideration and color code any matches in the column. Please help with excel cell color formula.