Filll range with "NA" if another cell has certain value

S

spyuk

Joined
Oct 28, 2011
Messages
1
Reaction score
0
I need a way to populate cells W:BH with "NA" if Q = "xhigh".
Any help appreciated!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation List (conditional) 2
Max 5
Searching for empty cells and changing values 6
Multiple Ranges and Find/Replace 1
Distinguishing 0 formatted as "na" and as 0 2
Excel Named Ranges and Conditional Format 3
Enter NA() into All Blank Cells in Range 16
Check for #NA in VB? 8

Back
Top