Conditional format coloring

[RJ1969]

Hello,
I am trying to set a conditional format to higlight the A:F when a text is being entered in F column.
See attached. I already set the conditional format but it only highlight the cell in F.

Thank you

[RJ1969]

Oh.... the word "text" contain only in F column. Thanks.

[Estevaoba]

Hi.

In Conditional Formatting, select Manage rules,
Then double click the rule you have created.
Then select "Use a formula to determine which cells must be formatted".
Then use this formula in the box "Format values in which this formula is true":
=$F1="text", and press OK
Then, in the "Applies to" box, enter this:
=$A:$F

Good luck!

[popipipo]

Then, in the "Applies to" box, enter this:
=$A:$F

Don't apply CF to whole columns that are 6 millions cells
use therefore

=$A$1:$F$100

[RJ1969]

Ok.. Thank you all. Really appreciate it.

[Estevaoba]

You're welcome. Glad to help.
Thank you for the feedback and for the reputation added.
Have a blessed day!