Previous Topic Next Topic

Conditional Formatting: Font color for entire column based on another column

Solved/Closed
Kitkatpdx
Posts
3
Registration date
Tuesday January 12, 2021
Status
Member
Last seen
January 13, 2021
 - Jan 12, 2021 at 09:49 PM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 - Jan 13, 2021 at 01:04 PM
Hi!
I would like to format an entire column so that if there is any entry in column B (in the same row) the font in column A will be blue, if there is an entry in column C, the font will be red etc.
I can figure out how to do the formatting one row at a time but I'd like to be able to format the first row and have the same rule in every row without having to manually put it in.
Thanks for your help!
Related:

3 replies

Answer 1 / 3
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 147
Jan 13, 2021 at 12:33 PM
KItKatpdx, Good afternoon.

Try to do this one:
Select the range you desire: ex.: A3:A50

Menu --> Conditional Format --> New rule

1) Use a formula to determine which cells to format:
Use the formula: =B3<>""
Format Font color as you want: BLUE -- OK

New rule
2) Use a formula to determine which cells to format:
Use the formula: =C3<>""
Format Font color as you want: RED -- OK

OK

Please, tell us if it worked for you.
I hope it helps.
1
Kitkatpdx
Posts
3
Registration date
Tuesday January 12, 2021
Status
Member
Last seen
January 13, 2021
Jan 13, 2021 at 12:35 PM
Perfect! That worked, thanks!
0
Answer 2 / 3
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 147
Jan 13, 2021 at 07:47 AM
Kitkatpdx, Good morning.

Since you can format a row, just change the range of cells in the formula for conditional formatting.

If you prefer, put here the formula you use and it works and so we can help you more quickly.
0
Kitkatpdx
Posts
3
Registration date
Tuesday January 12, 2021
Status
Member
Last seen
January 13, 2021
Jan 13, 2021 at 11:10 AM
This is what I've done to the one row. What results is that if there is a value in C3, the font in A3 turns blue (which is what I want).
0
Answer 3 / 3
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 147
Jan 13, 2021 at 01:04 PM
KitKatpdx,

Thanks for your feedback.

Glad to have helped you effectively.
---
Belo Horizonte, MG - Brasil.
Marcílio Lobão
0