Conditional Formatting: All Borders (Column A through E) if there is a value in Column A?

[CC268]

I just want some Conditional Formatting that will create 'All Borders' in that particular row (out to Column E) if there is a value in Column A.

So if there was a value in Cell A23 such as "Example 1" then I want it to trigger the 'All Borders' Command for that row out to Column E.

Thanks.

 

[JoeMo]

1.Select all the cells you want to format using your mouse (e.g. A1:E100).
2. Home>Conditional formatting>New Rule>Use a formula
3. Formula is: =COUNTA($A1)=1
4. Choose your format and click ok.

 

[CC268]

1.Select all the cells you want to format using your mouse (e.g. A1:E100).
2. Home>Conditional formatting>New Rule>Use a formula
3. Formula is: =COUNTA($A1)=1
4. Choose your format and click ok.

Perfect thanks!

 

[JoeMo]

Perfect thanks!

You are welcome - thanks for the reply.