highlighting

Can someone help me with a code which highlights a cell depending on the criteria of another cell. Example. In B1 I have the formula =NOW() (we all now what this means). In B2 I have a completion date. I would like A2 to fill with a specified colour. Can this be done so that it works...

Is there a formula that could say =If A3 CONTAINS THE SAME INFO AS A7 THEN TENT OR FILL A3 FORMULA BEING IN A3. thanks

I was wondering if anyone can help. I often have multiple tabs selected for a variety of different reasons, but since get excel 2007 I find myself accidentally copying information on to multiple sheets. This is because the shading of the highlighed tabs (at the bottom of the screen) changes do...

So in column C I used conditional formatting to highlight specific cells containing _B1, _B2, _B3, etc. Now that those are identified, I want to highlight their entire row the same color (basic yellow fill). Is there a conditional formatting, copy/paste formatting, or anything like that to do...

I have a worksheet that uses Data Validation lists, in one row there are three columns that use seperate lists. The first column contains vendor names, the second contains their priority (both cells have formatted colors) - I'd like to keep the "priority" cells formatted colors, but have the...

Hello, Is there a way to make a worksheet change event that will evaluate the cells in the range G42:J60 and highlight any cell that does not contain a formula? Basically if someone "types over" one of my formulas with a constant value, I want it to stand out with a yellow-colored highlight...

Hello Good people I was wondering if there's a way or a formula to highlight the entire row and column in which a cell is located. for example, let's say i have some data in the cell C10. when i select C10, all the cells from row A10 to C10, and the cells in column C1 to C10 should be...

Hi, I am looking for a manual as well as a VBA solution for this post. If you look at the attached image I need a solution to highlight a column (Col.2 in the case of my example) if the contents/value of Col.2 match Col. 1 Many advance thanks for your help.

I am using Excel 2007. I need to find duplicates based on three different columns. I took all three columns and combined them and then I used the conditional formatting that is built in to find duplicates in that column and highlight them. Here is where I run into the problem. I need it to...