Conditional Formatting Help

Hi there,

I need some help doing conditional formatting. We are developing a spreadsheet for clients to fill out and need spreadsheet to create red cells when a certain cell contains a value.

I've attached and example of the spreadsheet.

If someone says 1 day or 2 day in column C we need G5 to J5 to be highlighted in red if it's blank. When a value is entered in, the colour is cleared. Can anyone help? I thought I had the formula, but I would have to create it individually for each cell and it wasn't quite working.

Thanks heaps! Hannah

hi etaf,
So for example:
if "1 day" (or "2day) is entered in C10, then G10-J10 would need to turn red, (if there is no value in those cells).
If someone put information into those cells, then the red would clear away.

We are trying to show customers what they need to fill out after entering 1 or 2 day.

So if they enter 1 or 2 day into cell C10 or D10, then cells G10, H10, I10 and J10 would turn red. As the customer enters the information into those cells, it would go back to no colour, indicating to them that it was completed.


In the example spreadsheet I've attached, is just what I would expect it to look like when the customer is filling it out. With the red appearing/disappering as they enter the information.


Does that help?
Thanks heaps!
Hannah

YOU ROCK!!! Thank you so so very much!! This works perfectly.
Thanks heaps - you have made my day! :-D

Hi etaf,
ok so I thought it was done, but not quite...
I forgot about columns K and L.
So if C8 has 1 or 2 day written in the cell, I need L8 to turn red as well as G-J.
With D8, if that has 1 or 2 day written in the cell, K8 needs to turn red like G-J.
Does that make sense? I've attached your example with this new situation in it.
Is there a way to do that?
Thanks heapsexample_etaf1.xlsx,
Hannah

It almost works thank you.

But it highlights K8 when C8 is populated, when it should highlight L8.

And the same the other way around, when D9 is populated, L8 highlights red when it should be K8.

Is it just a matter of switching them around? As basic as that sounds....

Just absolutely Perfect. Thank you so much!!