Change the rows font colour based on one cell [Closed]

Report
Posts
1
Registration date
Tuesday April 8, 2014
Status
Member
Last seen
April 8, 2014
-
Posts
1842
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 27, 2020
-
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 reply

Posts
1842
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 27, 2020
136
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