condional formatting

There are so many articles on this and I have spent hours going through them. One returns the color of the Conditional Formatting and is so long just to find if it the conditions have been meet or not! I found this one that should work but it fails at the Evaluate function. Function...

I need to highlight cells that must be filled in. It is easy to do when you are only looking at the ActiveCell but I need several cell to be highlighted if they are blank and the main Category has been filled in. Example: A1 = Main Category B1 to E1 are sub categories. If there is nothing in...

I have been struggling with this for a while now. What I have works but is slow. I have a pivot table that I am generating in VBA on command and then I use the code below to run a conditional format. my problem is that I need row to have each number only compared to the others in the same row...

I have a list of 4000 Letters. Each letter has a revision 1 and revision 2 (so effectivly 8000 letters). Each revision has a response due date and actual response date. My query is: I would like to plot on a timeline showing in colour the delay period. (If the Actual response Date is > than...

I have several ranges of cells(=$G$5:$G$18,$C$5:$C$50,$K$5:$K$30) that I have conditional formatting on. Tcells turn red if they have duplicate values. What I would like is for a list of the values to show up in a range of cells such as G24:G36

Excel v.2010 | OS Windows 7 Problem: The gannt chart being produced with conditional formatting doesn't execute with cells that have vlook up data. I'm comparing a start time and an End time. The conditional formatting works when you type in the time directly into the cell. Files: Description...