format column cell background in a table if text entered

Copper Contributor

I have created a table, and in the SUBJECT column I want the background to turn grey when I enter any kind of text or number.

The first 2 columns TAG, SORT have conditional formatting. But I dont think that will work for what I want.

I have a table style applied as can be seen, but I want to have the cell turn light grey when I enter text into the next cell down the SUBJECT column is it possible?

 

formatting column cell if text entered.png

2 Replies

@Jitterbug23 

It's certainly possible.  But for any cells (column C cells, in your example) that already have conditional formatting, the order of the formats may be an issue to deal with after the following steps.

 

(The assumption below is that you are using a Windows version of Excel; menus for Excel for Mac or the web version may differ.)

 

Select kcell C2 and extend your selection down as far as needed.  From the Styles section of the Home menu, select Conditional Formatting and click New rule…  In the dialog that appears, click the entry for "Use a formula to determine which cells to format".  In the text box below "Format values where this formula is true:", enter =C2<>"" and click the "Format…" button to select the grey, etc.  Click OK as needed to close the dialogs.

 

 

@SnowMan55 
thanks for the help,
I tried that, and then even removed the table formatting afterwards,
but doesnt seem to work.

 

C2.png