ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional Format a row based on a cell? (https://www.excelbanter.com/excel-worksheet-functions/146823-conditional-format-row-based-cell.html)

WRCH5

Conditional Format a row based on a cell?
 
Hello,
I am wondering if MS Excel can do the below: If anywhere is column A
there is a "W" then make the entire row BOLD. Any ideas?
Thank You

Teethless mama

Conditional Format a row based on a cell?
 
Select entire rows, then enter the formula in the Conditonal Formatting
=$A1="W"

Format Font BOLD


"WRCH5" wrote:

Hello,
I am wondering if MS Excel can do the below: If anywhere is column A
there is a "W" then make the entire row BOLD. Any ideas?
Thank You



All times are GMT +1. The time now is 04:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com