Showing Invalid data

[Brad E]

I have validation on some cells. The validation on C4
references B4 to know what valid data is. If C4 is valid,
but then B4 is changed making C4 invalid, how could I let
the user know this?

I don't see any formula that can do this and be put in the
conditional formatting entry.

I just thought of something...If I put the same equation I
am using for validation in C5, then do a conditional
formatting on C4 that references the value (T or F) of C5,
would that work?

TIA, Brad E.

 

[John Michl]

One relatively simple way is to use a cell adjacent the cell that requires
validation to display a message if a certain criteria is met.

Example, in cell D4 enter an if statement such as =if(B4=C4,"","<--this is
invalid"). Format D4 to be bold and red or something that will catch one's
eyes. If cell passes validation, then nothing shows in D4. Be sure to
protect this cell so that the user doesn't type over the message.

- John
www.JohnMichl.com