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

%3CLINGO-SUB%20id%3D%22lingo-sub-2492812%22%20slang%3D%22en-US%22%3EFormat%20Conditioning%20a%20Cell's%20input%20to%20determine%20the%20color%20of%20the%20row%20in%20a%20table.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2492812%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%2C%20and%20am%20trying%20to%20make%20a%20format%20condition%20so%20that%20if%20I%20put%20a%20certain%20input%20into%20a%20certain%20cell%2C%20it%20will%20make%20everything%20in%20that%20row%20green%20with%20black%20letters.%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2492812%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2492940%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20Conditioning%20a%20Cell's%20input%20to%20determine%20the%20color%20of%20the%20row%20in%20a%20table.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2492940%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1090000%22%20target%3D%22_blank%22%3E%40ZacharyWalter%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20the%20sake%20of%20illustration%2C%20I%20will%20assume%20that%20the%20cell%20is%20C2%20and%20the%20value%20is%20%22Excel%22%2C%20so%20you%20want%20to%20format%20row%202%20if%20C2%20equals%20%22Excel%22.%3C%2FP%3E%0A%3CP%3EOr%20if%20you%20want%20to%20format%20multiple%20rows%2C%20row%202%20is%20the%20first%20of%20those.%3C%2FP%3E%0A%3CP%3ESelect%20the%20row%20or%20rows.%20A%20cell%20in%20row%202%20should%20be%20the%20active%20cell%20in%20the%20selection.%3C%2FP%3E%0A%3CP%3EOn%20the%20Home%20tab%20of%20the%20ribbon%2C%20click%20Conditional%20Formatting%20%26gt%3B%20New%20Rule...%3C%2FP%3E%0A%3CP%3ESelect%20'Use%20a%20formula%20to%20determine%20which%20cells%20to%20format'.%3C%2FP%3E%0A%3CP%3EEnter%20the%20formula%20%3D%24C2%3D%22Excel%22%3C%2FP%3E%0A%3CP%3ERemember%2C%20C2%20is%20the%20relevant%20cell%20and%20%22Excel%22%20is%20the%20relevant%20value.%3C%2FP%3E%0A%3CP%3EClick%20Format...%3C%2FP%3E%0A%3CP%3EActivate%20the%20Fill%20tab.%3C%2FP%3E%0A%3CP%3ESelect%20green.%3C%2FP%3E%0A%3CP%3EClick%20OK%2C%20then%20click%20OK%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.