I have a worksheet where cells V8 to V23 are required entries with a Y or N (I have the required part done for this range)
If any of those cells have a N entered, then K33 MUST be filled out.
I have figured out if V8 is N, then K33 must be filled out, that part works
I'm stuck at the entire range of V8 to V23
Here's what I have entered in the Conditional Format area (the part that works)
=AND(V8="N",K33="") the K33 cell turns red, indicating it must be filled in
My question is how to set the range for V8 to V23, I tried V8:V23, without success.
Thanks
Bookmarks