ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   colorize row if... (https://www.excelbanter.com/excel-programming/289835-colorize-row-if.html)

sal21[_5_]

colorize row if...
 
In the range A3:0 i have many rows filled whit a data, my prob is to
colorize font in entire row if in the column O is present the value
AAAA


---
Message posted from http://www.ExcelForum.com/


Grey Newt

colorize row if...
 
You need to look at conditional formatting (under the Format menu)

Tim Williams

colorize row if...
 
Select the data block

Format -- Conditional formatting

select "Formula is"
enter =($O3="AAAA")

choose a format
click OK

Tim.



"sal21 " wrote in message
...
In the range A3:0 i have many rows filled whit a data, my prob is to
colorize font in entire row if in the column O is present the value
AAAA


---
Message posted from http://www.ExcelForum.com/





All times are GMT +1. The time now is 01:31 PM.

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