Forum Discussion
How do I make excel change the colour of a cell depending on a different cells date?
Let's say you want to highlight a row if column F contains "Closed".
Use the formula
=$F2="Closed"
If you want something different, please provide more detailed information.
How can I make this formula work using specific words instead of a date?IngeborgHawighorst
Let's say you want to highlight a row if column F contains "Closed".
Use the formula
=$F2="Closed"
If you want something different, please provide more detailed information.
What if the same conditional format can be based on two differing texts in a single cell, such as =$F2="Closed" as well as "Closed-Ext". I'm not sure how to combine that in one conditional formula...
- Excellent! Thank you for the speedy reply!
HansVogelaar what if I need a cell to change to be white if the adjacent cell is left blank I tried =D3=“BLANK” but that didn’t do the trick
HansVogelaar that did the trick
now one more question I want C3 to change green if D3 falls between the value of 8.00-9.49
i already have the formulas for if it’s less than 7.99 it turns yellow =$D3<(7.99), and more than 9.5 it turns red =$D3 >(9.5) in place.
any idea what formula might work for 8.00-9.49?
- I have two sheets that are connected with formulas,when I change data in sheet 1 it changes in sheet 2.I want to ask what do I have to do,when I change data in sheet 1 to appear in another colour in sheet 2.
You can use conditional formatting referring to the values of the cells on Sheet2, just like when you enter the data there directly.
I would like to know how to highlight any of the rows in column I with a colour based on whether Yes or no Have been entered into the sections highlighted
IE - if D2 has 'Yes' entered then I2 would turn Green
Select I2:I8 (or further down if you like).
I2 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=$D2="Yes"
Click Format...
Activate the Fill tab.
Select green as highlight color.
Click OK, then click OK again.Thanks very much for the help.
Is there any reason why this box:
Keeps appearing, when I follow the instructions, nothing happens.
HansVogelaar if I want to change a cell color based on a collumn in a different sheet containing the number 221 how do I do that?
So for instance I need my cell to turn green if any cell in column C on the second sheet titled testdone contains the number 221
Create a rule of type 'Use a formula to determine which cells to format' with the formula
=ISNUMBER(MATCH(221,testdone!$C:$C,0))
Your answer help me
If cell A8 contain a "text" and D8 contain a text that can be "closed" or "Open"
And i want to change the color of A8 based on D8 text, that is clear to me by using your used fourmla
My inquirry, but if i want to repeat above fourmla for each raw such as
A9 based on D9
A10 based on D10
A11 based on D11
and roll gose on
- YES! That is exactly what I was looking to do. Many many thanks Hans. I so appreciate your help.
