condinational format

Hi, In a range I have a conditional format to colour cell if = "H" but when I delete the cell contents the colour still remains, I don't know why this has started to happen i'm sure before the cell returned to a no fill status. Any ideas?

I would like to be able to format K6 with a fill of red if G6 has text selected from a drop down AND K6 is empty. If G6 is empty id like the K6 to be left alone. i tried =AND(G6="*",K6="") in the conditional formatting section but it is not working.

I hope someone can help. I have an excel sheet with over 65,000 rows. I have attached a picture of what I am trying to achieve The problem I am facing is that i have a worksheet with 65,000 rows, and I have payments and reimbursements withing these rows. In the below screen shot you can see...

Hello, I am using Excel to create a calendar and I am using the formula to highlight all cells between date. <tbody> =AND(R$22>=$I23,R$22<=$J23) </tbody> Where R22 is the first date of my calendar which is going by weeks and I23 & J23 are dates. EG. R22 is 1st jan and I23 & J23 are...

Hi, I need to create something which I don't know how to explain, and which I don't know how to do, but which I believe to have something to do with conditional formatting :) Here's what I need to do... Cell A1 sums up the values of cells A2 - A32, and returns the total number (duh!). And...

Hello there, I'm using Excel 2007, and I have been struggling to find the correct conditional formatting for my data. What I have are 4 columns. The first column contains a Job Number(all job numbers are unique), the other three columns contain lot numbers associated with a component of the Job...

<tbody> Expiry Date 2014 2015 31/11/2014 (black color) 31/12/2014 (black color) 31/01/2015 (black color) 25/05/2015 (black color) </tbody> Hi Everyone, Can someone please let me know who can i make those cell black or whatever color if the expiry date falls in the period? Thanks

I am relatively new to Excel and need to figure out how to do the following for a project dashboard template: For example: Cell A2 is 2014/01/01 (YYYY-MM-DD) Cell B2 is 2014/03/01 Cells C2-N2 will represent 12 months duration of projects. I need some kind or formula or conditonal formatting...

Hi to everyone, I`m new to this forum so please bear with me. In essence, i was trying to add conditional formatting to SUMIF so differentiate between cells in various colours but can`t work out how go about with entering the colour condition. Has anyone got any suggestions, please?

Hi, I'm really new to this spreadsheet stuff and I can't seem to find a simple answer to this question... How do I make a cell change to another cell's value based on the value of a third cell? That's a confusing way to ask, perhaps. I have quantities (1-12) and different dollar amounts for...