Conditional Formatting on Row using Count function

[BarryGallegos]

Hello my fellow colleagues,

I for the life of me cannot figure out how how to get this done.
I have a Row where the cells in column A will contain Words such as Open, In Transit, Received, Scheduled, Delivered, Closed.
That row will stretch with columns from A - W. When the Word Closed appears on Column A, I want all of the text on that row from Column B - W to change to Grey.


I Cannot for the live of me figure this out....

Please, and Thank you in advance.


Barry

 

[Eric W]

Welcome to the Board.

Select columns B-W. Click Conditional Formatting > New Rule > Use a formula > and enter:

=$A1="Closed"

Click Format... > Font > Color > and choose Gray. Click OK.


Hope this helps.

 

[Norie]

Barry

You don't need Count for that.

Select the rows/columns you want to apply the conditional formatting to.

Goto Format>Conditional formatting...

Select the Use formula to determine cells to format... option.

Enter this formula, changing the 2 to the first row of the range you selected at the start.

=$A2="Closed"

Click Format..., select the formatting you want then click OK, click OK, click OK.

 

[BarryGallegos]

Thanks Guys, That did the trick.

I really appreciate your support!

 

[Eric W]

Glad we could help!