Change the rows font colour based on one cell

Closed
RDyman Posts 1 Registration date Tuesday 8 April 2014 Status Member Last seen 8 April 2014 - 8 Apr 2014 à 03:04
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 8 Apr 2014 à 08:24
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 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
8 Apr 2014 à 08:24
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