colorize row if...

sal21 · Jan 31, 2004

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

Guest · Jan 31, 2004

You need to look at conditional formatting (under the Format menu)

Tim Williams · Jan 31, 2004

Select the data block

Format --> Conditional formatting

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

choose a format
click OK

Tim.