Get instant live Excel expert help with conditional formatting

Use conditional formatting to identify all AvgRev values where the AvgRev is more than 5% greater than the AvgRev FOR THAT CARCLASS calculated in Item 17 above. DO NOT USE the calculated AvgRev number, instead USE the cell contents of the AvgRev value so that if either Revenue or NumCars change in a particular row that the conditional formatting is based on the updated value for Average Quarterly Revenue

Conditional formatting where a number is higher than than in another cell... should be straightforward... BUT as that other cell is calculated to include VAT and may show a rounded up figure, I am finding sometimes that even though the value shown is the same (EG £20.25) if the ACTUAL value of the cell being checked is £20.2487, the conditional formatting is triggered incorrectly! Any ideas please?

I need a conditional formatting to identify all AVG Rev values in Columns E and F that are 5% greater than the AVG REV in column K

How do i represent in a table, using conditional formatting, 5% greater than another cells predefined value.

I need a simple formula for conditional formatting which will light up a cell if the date in the cell approaches within 30 days from todays date. Example if a cell had 9/30/2018 in it, and today's date is 9/11/2018, the cell would light because todays date is less than 30 days away.

I'm trying to copy conditional formatting in cell C5 on the sheet "Skins" to D5 - T5. I'm able to copy conditional formatting when I don't have $ in my formula but when I include $ in my formula the code doesn't copy properly. This formula requires $'s. Is there a way to copy conditional formatting from one column to the next without having to manually re-write the code for each column?

1. I have some conditional formatting rules set for the pivot table“Cycle Time”. Whenever the pivot table auto refreshes the conditional formatting is lost. Applying rule to entire column doesn’t work and the formula changes on its own. 2. On the sheet named “Individual Rep Productivity” filtered cells have been marked “remove blanks” under the drop down in A1. Formulas on this sheet pull from other sheets. Blank cells that are filled and later times and will populate. I would like for this to automatically update without having to check the box next to blanks and then uncheck it again for the new data to show up.

I need help with conditional formatting, sheet GROUP SALES MANAGEMENT, if statues is CANCELLED or NOT RESERVED i need column A-G to have the background white

Conditional Formatting to Multiple Workbooks - or Worksheets. I have 20 Workbooks that I want any cell in with an "M" background color to change to Green, "A" to Yellow and "N" to Red.

If difference between end shift and start shift(column C and column E) is <8 hr then d3 is red. Conditional formatting will be needed.