Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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
1914
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 7, 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!

3 replies

Answer 1 / 3
Posts
1914
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 7, 2021
 142
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.
Comment
1
Thank you
Thank you

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 2942 users have said thank you to us this month

Report
Posts
3
Registration date
Tuesday January 12, 2021
Status
Member
Last seen
January 13, 2021
Perfect! That worked, thanks!
Answer 2 / 3
Posts
1914
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 7, 2021
 142
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
1914
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 7, 2021
 142
KitKatpdx,

Thanks for your feedback.

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!