conditional formatting

[biglb79]

is there a conditional formatting rule I can use that would highlight cells A268:d268 in red if F268 is #N/A? the rows will increase that's just where it's at now. I have a Vookup in column F to look at number in column D and it's #N/A people shouldn't add the information but they still do. I'm hoping if it highlights red then they won't

 

[Joe4]

Select cells A268:D268, and then apply this Conditional Formatting rule:

=ISNA($F268)

and choose your red formatting option.