Simple Conditional Formatting formula to revert line item back to normal after selecting from drop-down menu?

[booleanboolean]

Hi all,

I can't figure this out for the life of me, but I basically have a call log with many columns. The columns involved here would be column H "Request Type" and Column N "Status."

I have a formula for column H where the row will highlight if the request type "Shift Swap" from a drop-down menu is selected. The row will highlight in fuchsia. I now need another formula for column N (Status) that will revert the same line item back to normal once a user selects "Completed" from column N.

This may involve an IF statement under conditional formatting, but I'm a newbie and can't figure it out. Please refer to the picture (hopefully it uploaded), but basically once "Completed" is selected, the entire row needs to revert back to normal.

Thanks in advance.

 

[etaf]

in conditional formatting use the following formula

=And ( $H1 = "Shift Swap", $N1 <> "Completed" )

if the whole columns are selected as the range to apply to
Otherwise , use the first row in the range
if the range selected for conditional formatting is A5:Z2000 then use the first row 5

=And ( $H5 = "Shift Swap", $N5 <> "Completed" )