Previous Topic Next Topic

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

Solved
Report
Posts
3
Registration date
Tuesday January 12, 2021
Status
Member
Last seen
January 13, 2021
 -
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
 -
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
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
 147
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.
Report
Posts
3
Registration date
Tuesday January 12, 2021
Status
Member
Last seen
January 13, 2021
Perfect! That worked, thanks!
Answer 2 / 3
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
 147
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.
Report
Posts
3
Registration date
Tuesday January 12, 2021
Status
Member
Last seen
January 13, 2021
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).
Answer 3 / 3
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
 147
KitKatpdx,

Thanks for your feedback.

Glad to have helped you effectively.
---
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Reply Ask a question