Forum Discussion
Format Conditioning a Cell's input to determine the color of the row in a table.
I have a table, and am trying to make a format condition so that if I put a certain input into a certain cell, it will make everything in that row green with black letters. Any ideas?
2 Replies
Hello ZacharyWalter,
If the input is a string, then that could be:
=$A1="abc"
If the input is a number, then that could be:
=$A1=1
Then format the fill and font as you wish and apply the conditional format to the appropriate row.
For the sake of illustration, I will assume that the cell is C2 and the value is "Excel", so you want to format row 2 if C2 equals "Excel".
Or if you want to format multiple rows, row 2 is the first of those.
Select the row or rows. A cell in row 2 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula =$C2="Excel"
Remember, C2 is the relevant cell and "Excel" is the relevant value.
Click Format...
Activate the Fill tab.
Select green.
Click OK, then click OK again.
