Format Conditioning a Cell's input to determine the color of the row in a table.

Copper Contributor

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

@ZacharyWalter 

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.

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.