code conditional format macro?

[Asus]

Got a bit of rust on the brain cells.. I would like some help from the pro's out there please.
I have a sheet that when a cell has meet a condition the "A" cell in that row changes a colour or a pattern is added to that rows "A" cell. How would I make that condition extend across the row for say 19 cells? I do not want to do it by my ugly clumsy thought make each cell coniditional on the previous ( ie 18 conditonals for based on the one "A" cell.

Thanks in advance
Great to see all this help out here. Very refreshing
Knowledge is power.. True power comes when knowledge is shared

 

[Von Pookie]

- Select all of the cells in that row that will have the formatting applied.
- Set the conditional format as a formula. For example, =$A1="Yes"
That will apply the formatting you choose for all of the selected cells if the cell in column A of that row contains the word "Yes."

 

[Asus]

Thank you
I found my problem why I had problems now though. A hidden column that was locked'
Works fine now