Solved: Colour cell based on range value

[khalid79m]

I need help writing the following code,

If Named range final_check is equal to complete then select that row from a to bc and colour it green,

Please not the range final check is a column of data.

Can anyone assist

[Bob Phillips]

Select A:BC for all the rows that you want to check and use conditional formatting with a formula of

=INDEX(final_check,ROW())

[khalid79m]

perfect works good