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.
In previous post
"Tomorrow I will insert the column for the October 9th"
That means you are expanding the range, isn't it? Or you always have exactly the same number of columns?
wjwhittle , you are welcome
SergeiBaklan Thank you! works perfectly
For the blue you may use conditional formatting rule with formula
=COUNTIF($H:$H,B1)applied to $B$1:$F$50.
Another similar rule is for red.
- Hi Sergei,
This thread seems the closest I can find, I have a list of students in Column H and a List in Column I
I need to swap in and out between H and I.
When in H I want cells B1: F50 if they match what is in H to be blue and if in I to be red
What conditional formatting formula do I need so I don't need to individually match and change the colour if I move into the other column?
TIA When I insert a column - it seems to inherit the formatting - so its AutoMagic !
I keep the most current stats on the left of the sheet next to the legend - the Old data moves out to the right ...That means you may apply the rule to the range $B$2:$XFD$1000000 if you don't care about performance, but it's better to take more realistic gap.
