I apoligize for the redundancy of this question, but all the post's I have seen on this subject have not dealt with my particular problem. I am attempting to...

Is it possible to set a conditional format in a cell which has a formula so that when a value appears in that cell, the cell background changes colour. When...

How do I do a conditional format saying that if A6 has nothing in it then turn J6 a certain colour.

I'm trying to apply conditional formatting on the entire row if condition is met. The Column the conditon is in M. How would I accomplish to turn each...

Is there a way to conditional format a cell that does not have a formula. It does not matter what the formula is as long as it does not have one. I allow users...

Is there a way to use a conditional format which will color a cell one way if the value is either "VIP" or "Prem"? I have conditional formats in condition 1...

Dear All I, create conditional format related to one column data range showing the staff ID, I want when I enter the staff ID if it is available in my data...

Hi, I want the color of the text in cell B1 to change depending on the value in cell A1 How can this be done? I know I can do it with conditionale...

Hello, I would like to set a conditional format to color each unique value a different color. It will also be applied to multiple occurences of the value....

I want to highlight a cell based on two conditions: I want to highlight cell A1 if the date in cell A1 is over 14 days older than TODAY() and cell J1 is...

Hi - wonder if someone can help me with this one What would be the conditional format for - if current month = date in cell A1 then apply format. i.e. date...

That's what I was messing up! It was the ordering, not the formula! Thank you. Now if I have my =AND(E2="Y") for one and no formatting, and my second...

I have a cell which only appears as an input cell only if another condition is true. Its standard format is no fill with white font so that it doesn't appear...

Hi .. Can someone help please ... struggling I need conditional format formula which allows me set a colour to the row on if the cell value in a colume is...

I see that I can only use 3 conditional formats. I need a few more than 3 is there any way to do this. Kevin

I would like a cell to turn red if I enter L or PB. Normally I would use a 2 conditional formats 1 for L and 1 for PB, but I need more than 3 conditional...

I am making a training schedule, and I need a bit of help. In each workbook, I have 12 sheets 1 for each month. Let’s say Joe is up for retraining on March...

is there any way to have more than 3 conditional formats or something like doing it by formula? thanks in advance

How can I apply a conditional format to a different cell? For example: I want to format cell B1 based on the value in cell A1. So if the value in A1 was =...

I need a conditional format formula that says if D1 = "N" than cells B1&C1 should be gray. What should I type in the conditional format statement?