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 1983 Registration date Monday August 16, 2010 Status Contributor Last seen February 27, 2023 - Apr 8, 2014 at 08:24 AM
Mazzaropi Posts 1983 Registration date Monday August 16, 2010 Status Contributor Last seen February 27, 2023 - Apr 8, 2014 at 08:24 AM
Related:
- Change the rows font colour based on one cell
- Based on the values in cells b77 b81 ✓ - Excel Forum
- How to change account based in instagram - Instagram Forum
- Crimping colour code - Guide
- Excel change font color based on value of another cell ✓ - Excel Forum
- Excel duplicate rows based on cell value ✓ - Excel Forum
1 reply
Mazzaropi
Posts
1983
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 27, 2023
146
Apr 8, 2014 at 08:24 AM
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
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
