Conditional Formatting

[Jase]

HI All

I have a slight problem that I was hopeing that someone
knows how to fix. What it is is I have three data
validations next to each other (so in columns(B, C and D)
now the validation in column C depends on the one in
column B and the same with column D and C.

The problem is that sometimes the value in column C means
that I do not need a validation in column D so is there a
way to color that cell to show the user it is not needed?

I hope this is not to confusing

Thanks heaps
Jase

 

[Paul]

HI All

I have a slight problem that I was hopeing that someone
knows how to fix. What it is is I have three data
validations next to each other (so in columns(B, C and D)
now the validation in column C depends on the one in
column B and the same with column D and C.

The problem is that sometimes the value in column C means
that I do not need a validation in column D so is there a
way to color that cell to show the user it is not needed?

I hope this is not to confusing

Thanks heaps
Jase

Yes. Use Conditional Formatting on column D with a suitable formula that
refers to the value in column C. Use relative references so that D1 will
depend on C1, D2 will depend on C2, etc. So, for example, if you want to
colour a cell in column D when the value in the adjacent cell in column C is
greater than 10, select column D and apply conditional formatting with the
formula
=(C1>10)