Conditional Formatting: Font color for entire column based on another column
Solved/Closed
Kitkatpdx
Mazzaropi
- Posts
- 3
- Registration date
- Tuesday January 12, 2021
- Status
- Member
- Last seen
- January 13, 2021
Mazzaropi
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Related:
- Excel conditional formatting based on another column
- Excel conditional formatting entire column based on another column - Best answers
- Conditional formatting based on another column - Best answers
- Excel conditional formatting based on another cell text ✓ - Forum - Excel
- Excel conditional formatting based on date and text in another cell - Guide
- Excel conditional formatting applies to multiple columns ✓ - Forum - Excel
- Highlight cell if another cell contains any text ✓ - Forum - Excel
- Excel conditional formatting based on month - Forum - Office Software
3 replies
Mazzaropi
Jan 13, 2021 at 12:33 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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.
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.
Mazzaropi
Jan 13, 2021 at 07:47 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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.
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.
Kitkatpdx
Jan 13, 2021 at 11:10 AM
- Posts
- 3
- Registration date
- Tuesday January 12, 2021
- Status
- Member
- Last seen
- January 13, 2021
Jan 13, 2021 at 11:10 AM
Mazzaropi
Jan 13, 2021 at 01:04 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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
Thanks for your feedback.
Glad to have helped you effectively.
---
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Jan 13, 2021 at 12:35 PM