conditional

Hi everyone! I haven't posted any issues for a while, but this one really got me or I'm just getting older :) Basically I would like to format the cells based on the result of a lookup value from another table. I managed to apply the index match formula to return the value, that needs to be...

I am trying to create conditional fomatting that changes the background color of a cell based on a simple conditional formula, but I want the color to come from the background color of another cell. For example, assume I want to create conditional formatting that changes the background color of...

So, I have a billing spreadsheet with a list of names in column E. I have pay columns that are based on years of experience. The names in Column E contain an * if they are first year and ** if they are 2nd year. What I want to do is change the background colors depending on * or **. I've...

I am trying to do some conditional formatting based upon 2 conditions. I have a column (S) that contains a number. I have a column (G) that contains a Y or N. I would like to highlight any cells in column G where it contains a "Y" and where column S in the same row contains the number 1. I...

I know how to conditionally format for duplicates. Is there a way I can format only those text values that show up, say, 4x or more, instead of 2?

Hi, I have a formula where I am checking if a cell is blank = if(a1="","",do math) I am then applying conditional formatting to cells above a number. Any of the cells that are true or "", get applied that conditional formatting even thought it is blank. Any ideas? I do not want "0" to show in...

Could anyone please advise on conditional formatting? I'm trying to use a formula to have say cell a1 to change colour IF cell d1 has any input? I've been trying conditional formatting in cell a1 as - If(d1="",TRUE,FALSE) but no change happens with input to cell d1. Any help would be greatly...

I have a sheet that has a ton od conditional formatting. I need to let users add data in all areas, but want to lock all the conditional formatting and still be able t paste into the cells etc. Is there a way to do that?

Using countif doesn't work because formula in CF (= i don't wanna enter conditional formatting always) is too long with many other functions and there are 4 cells. Is there any other way to get results of formulas in CF outside CF? Thank you.

Hi all. Wonder if anyone can help. How do you put this formula into a conditional formatting formula based on if the answer is “Pass” the cell is green, “Inter” the cell is yellow and fail it’s red. PASS =IF(SUM(D3:$H3)<=$C3 INTER =IF(AND(SUM(D3:$H3)>$C3,SUM(E3:$H3)<$C3) FAIL = any other...

I'm having trouble learning this "loop" feature in vba, or even if it's the correct way to do what I'm wanting. I'm looking at changing the day's background fill, or the "interior". I figured out how to do it one box at time, but it seems as though that probably isn't the BEST way to do it and...

Could someone please help me to create a VBA script which applies the following three conditional formatting rules? Rule 1 Rule 2 Rule 3

Hi everyone, I thought this issue would be simple but it's actually proving to be quite difficult. I need to write a formula that will return the last balance for an account within a table of multiple accounts. Essentially the formula needs to look at the MAX date for all transactions...

Conditional formatting does not apply to dates less than TODAY(), only greater than TODAY(). I have an IF statement with two VLOOKUPS inside. One of them outputs "Not Registered" if the cell looked is empty. The other, just copy the data that is on the other spreadsheet. <code style="margin...

Hi, I have used the formula below to apply conditional formatting to the cells in my worksheet. The conditional formatting is based on the result of inputting a value in the column heading and a value in the row headings. The problem I have is that all results are the same colour. I need the...

So I have an issue sorting data and then using conditional formatting on that data. he data that I start with has numbers in a 2dp format and my conditional format rules work on whole numbers. I dont need the numbers to be 2dp and none of the conditional formatting works until I manually enter...

How do I use the conditional formatting option for "Use Formula" option on a per row basis? In my example I have a status field as Closed, once the status is set to Closed it will Strike Through all the text in the next 5 columns in that row. How do I drag this Conditional Formatting...

Hi, Is there a way to use a transparent conditional formatting to put a "shade" over cells with true? The result i'm looking for is let's say a cell has already been manually highlighted with a specific color, if the conditional formatting is true, than a color with transparency will be shown...

I have a Toggle Button, linked to C1, which returns a TRUE/FALSE. What I want to do is change the font formatting of a <Text Range>, based upon the result in C1 If C1=FALSE, then <Text Range> displays in the default font (Arial, 10), but If C1=TRUE, the <Text Range> displays in (Times Roman, 12)...

I am having problem understanding the logic of the top 10% rules in conditional formatting. What does this mean? https://www.youtube.com/watch?v=T64RLaLngbc