Conditional Formatting

[DogmaDot]

columns a b c d e f g h i j k l m n

column d contains peoples names
Column n contains F or is blank
I want to highlight the name in column d if the corresponding cell in column
n is blank

 

[Dave Peterson]

Select your range (D19999, say)

With D1 the activecell
Format|conditional formatting
Formula is:
=n1=""

You could also use:
=n1<>"F"

since you only use F or blank.