conditional formatting based on content of another cell

HansVogelaar 

I am having trouble with the highlight cell rules. I want to create a rule that turns a B cell green if it has the same value as the D cell in it's same row. I need this to apply to both columns though. Everytime I try I can only get the B column to format itself to just one D cell, not the D cell in the same row as a given B cell. In other words it won't let me select a range.

Can you help?

HansVogelaar 

How do I format the column next to another if I want it change colour only if the number in the cell to the left is equal to or higher than a 3?  I managed to use your previous formula if any number is entered but need one for if a 3 or more is entered and simply can't figure it out!!

Thanks

HansVogelaar Hello. Is it possible to highlight a range of cells in a single row based on the value of another single cell in that same row, and for this process to be replicated to the rows below? In my case I need the following to apply. If F2>2.5, highlight A2:D2 and if F3>2.5, highlight A3:D3 and so on. 

HansVogelaar 

Hi. I'm wondering if you can help me, too.

I am tracking weights in a spreadsheet and want to use conditional formatting to turn a cell either green or light red based on the weight from the previous day. Green if the weight has increased; red if it has decreased. my cell ranges are B2 through BF9 to account for now until July 13th.

Thank you!

HansVogelaar 

Hi,

I am also trying to apply conditional formatting to change the colour of a cell based on the value of a different cell but without replacing the value of the cell.

I already have other conditions set up for the other cells whereby when I enter a number value into C column, the value in the corresponding E column cell automatically changes to Low, Normal, or High, and also changes to blue, green, or red respectively.

I'm having issues with the final step, ideally. When a cell in column E changes to a colour, I want the same cell in column C to change to the same colour but without replacing the value in the C cell. 

I have managed to find a way to do it for each individual cell but can't get it to work for the entire column with 1 formula.

For example I selected C4 as active cell and applied the condition formula =E4="Low" and selected fill as blue. Now when E4 reads Low C4 turns blue. But I'm struggling to work out how to apply this to both columns without having to do  all cells individually. I thought I sussed it but then my entire C column turned blue based off the value of E4 but I want each cell to respond individually to its adjacent cell. 

So C5 changes only based on E5 and C26 changes only to E26 etc.

I know I need to repeat 3 separate formulas for each colour but struggling to get the first one sorted

HansVogelaar I have been reading this series of Q&A and trying to follow. My question is regarding keeping the color in a cell as future data changes. Trying to track staff production. I have it all set with colors and conditional formatting. However, as their experience levels goes up so should their production levels. As I change their experience level (3,2,1), the previous cells do not retain the same colors previously assigned. Example: if you are experience level 3, you should produce 10 items weekly, red if 0-7, yellow if 8-9, green if 10 or above. Then as the experience level changes to 2, production should increase to 15 weekly, color are the same but increase to 0-12, 13-14 and 15 or higher. Yet, when I enter data on the first cell after the exp. level change, all colors turn and remain the same as the last color. I cannot figure out how to keep the colors as they were to show historical data/production via colors and not just numbers. Thanks for any assistance. 

HansVogelaar  Hello. I want to apply conditional formatting to cells in one column based on dates in another column. In this case the date format is 2024-01-01. I have entered the formula =ad28=2024-01-01 to a cell where this is True and nothing happens. The formula looks the same to me as your example =B2<>" so why is it not working? Thank you.

HansVogelaar 

Awesome! That works perfectly! Thank you Hans Vogelaar! Hope you are keeping well and safe.