Change the rows font colour based on one cell

Closed
RDyman Posts 1 Registration date Tuesday April 8, 2014 Status Member Last seen April 8, 2014 - Apr 8, 2014 at 03:04 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Apr 8, 2014 at 08:24 AM
Hi

I would like to create a rule to change the whole rows font when something is put into any cell in column V - who do I do this?

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Apr 8, 2014 at 08:24 AM
RDyman, Good morning.

Select the lines or cells you want
Suppose lines 3 to 10
Use the Conditional Format
Using formula
=AND($V3<>"";$V3<>" ")
Choose the font colour you prefer.
OK

Is it what you want?
I hope it helps.
Belo Horizonte, Brasil.
Marcílio Lobão
0