Indirect Formula to highlight row

[chrisbellman00]

Drop down list:
OK
X
"BLANK" (actually blank)


I have a created the following formula to highlight an entire row red and white gradiant when X is selected from a drop down box:

=INDIRECT("J"&ROW())="X"

When I select OK the highlight reverts back to the original color; however, when I select the blank option the row gets buggy. At times when I go from X to blank I have to highlight the row with my cursor for the red color to disappear. Conversely when I go from Blank to X I must do the same thing.

Is there an "AND" forumula or something I may use? (The orginal background color for the row is purple and white gradient).

Thanks,

Chris B.

[Jacc]

I had a similar problem once. I was using datavalidation from list and I wanted one option to be blank cell. The VLOOKUP returned error. I changed the empty cell in the list to ="" and then it worked. Maybe something like that?