condittional formatting

Hi All, I am trying to create a conditional formatting rule for a working spreadsheet we use at work. We have column A listed as a specific account new to our business. The person working on that item has their name in column B. In Column C it is left blank until that Item is completed then we...

Hello, I need some help using conditional formatting. I have a spreadsheet with employee payroll data. In column A I have a formula that numbers the row. I did this, so that when I filter the data based on salary amount over a $ threshold, I could have a numbered list. The formula that I have...

Hello Excel Geniuses! Hope all is well. I am in need of some assistance, and I am hoping someone can help me here... I have a workbook where months, expressed as the 1st of the month, are in row 2. Each column to the right is the subsequent month. SO for example, 10/1/2015 in BW2, 11/1/2015...

Hi, I created a conditional formating with Icon Sets and I am referencing a cell in another sheet that contins percentages. This are the two values I have for the Icon Sets: >= ='YTD VLU'!$B$46 >= =YTD Chg'!$B$46-0.04 When I create this conditional formatting it works perfectly but when...

Hello, I have Excel 2008 for Mac and want to do Conditional Formatting. I want to highlight all cells that contain a certain word. For example: I want to select all cells with the word "group". So, A2 which contains "group theme", A5 with "group meeting", etc. I can do conditional...