Conditional Format a Range of cells based on a specific text in one column

[hrdpgajjar]

Hi all,
I've a table range from A1 to C5

and now if Cell A1 to A5 has a specific text "On Line" then i want to highlight that row only.

i.e. if cell A1 has value "On Line" than i want to highlight row A1 to C1 only.

Also note that cell A1 to A5 will get its value by VLOOKUP (not by manual entry)

How can I do this by applying conditional formatting ?

Thanks

 

[arthurbr]

Select A1:C5
Use the following CF

=COUNTIF($A1:$C1,"*On Line*")

Format as required

 

[hrdpgajjar]

Select A1:C5
Use the following CF

=COUNTIF($A1:$C1,"*On Line*")

Format as required

Thanks it works

 

[smozgur]

Thanks it works

The marked solution post has been switched accordingly.

@hrdpgajjar: In your future questions, please mark the post as the solution that answered your question instead of your feedback post as it will help future readers. No further action is required for this thread.

 

[arthurbr]

@smozgur Thank you

 

[smozgur]

@smozgur Thank you