Highlighting a range of cells only if any cell in that range contains any text.

[amaresh achar]

Hello,

I am looking for a conditional formatting formula to highlight a range of cells only if any cell in that range contains any text, (as explained below):

I have a cell range J23:S23. If any cell among this range contains any text, then entire cell range J23:S23 should be highlighted in yellow.

I want format paint this formula, to 1000 such ranges up to J1036:S1036 (if I get formula for single range)

Or even a single formula (if possible) to cover entire 1000 rows also welcome...

Thanks in Advance...

 

[amaresh achar]

The second column states where to set up the CF. e.g. $J$23:$S$23.

Set the CF's for $J$23:$S$23 first and test it.

Tried.. but it isnt working as per my requirement.. if the cell are blank... then only that cell is highlighting in yellow.. I think I am not getting it right.. can you please apply that rule on a sheet and share it...??

 

[Herakles]

Tried.. but it isnt working as per my requirement.. if the cell are blank... then only that cell is highlighting in yellow.. I think I am not getting it right.. can you please apply that rule on a sheet and share it...??

View attachment 95755

Can you post an image, using actual data, to indicate what you need. Having all cells with the same value does not help.

 

[amaresh achar]

Can you post an image, using actual data, to indicate what you need. Having all cells with the same value does not help.

ok.. the sheet I attached is basically the afterworks of this post:

Switch cell with color based on 3 different conditions

Hi.. I need help with conditional formatting using formula: I have the following values in my sheet: E18: 287.2 F18: 289.2 If J18 is blank, then NO FILL ; If J18 cell value is between cell values of E18 and F18, then fill J18 cell with LIGHT GREEN background color and DARK GREEN Text color...

www.mrexcel.com

I have the following values in my sheet:

E23: 287.2
F23: 289.2

If any cell in the range J23:S24 is blank, then NO FILL.

If any cell in the range J23:S24 has value which is between cell values of E23 and F23, then fill that cell with LIGHT GREEN background color and DARK GREEN Text color else fill that cell with LIGHT RED background color and DARK RED Text color.

If any cell in the range J23:S23 has text, then highlight the entire J23:S23 range.
If any cell in the range J24:S24 has text, then highlight the entire J24:S24 range.

I am creating the excel sheet to explain this .. I will post it shortly..

 

[amaresh achar]

ok.. the sheet I attached is basically the afterworks of this post:

Switch cell with color based on 3 different conditions

Hi.. I need help with conditional formatting using formula: I have the following values in my sheet: E18: 287.2 F18: 289.2 If J18 is blank, then NO FILL ; If J18 cell value is between cell values of E18 and F18, then fill J18 cell with LIGHT GREEN background color and DARK GREEN Text color...

www.mrexcel.com

I have the following values in my sheet:

E23: 287.2
F23: 289.2

If any cell in the range J23:S24 is blank, then NO FILL.

If any cell in the range J23:S24 has value which is between cell values of E23 and F23, then fill that cell with LIGHT GREEN background color and DARK GREEN Text color else fill that cell with LIGHT RED background color and DARK RED Text color.

If any cell in the range J23:S23 has text, then highlight the entire J23:S23 range.
If any cell in the range J24:S24 has text, then highlight the entire J24:S24 range.

I am creating the excel sheet to explain this .. I will post it shortly..

 

[Herakles]

Will a row ever have a mixture of 'alphabets' and values that need the red / green formatting?

A realistic example of the data with all possible scenarios will be good.

 

[amaresh achar]

Will a row ever have a mixture of 'alphabets' and values that need the red / green formatting?

A realistic example of the data with all possible scenarios will be good.

"Will a row ever have a mixture of 'alphabets' and values that need the red / green formatting?" - No there will never be such case... even such case is simulated, then I want to highlight entire row in yellow.. (Including the cells containing values in that row)

They are almost realistic examples.. but ok I am preparing some examples for you... I will post it as soon as I complete..

 

[amaresh achar]

"Will a row ever have a mixture of 'alphabets' and values that need the red / green formatting?" - No there will never be such case... even such case is simulated, then I want to highlight entire row in yellow.. (Including the cells containing values in that row)

They are almost realistic examples.. but ok I am preparing some examples for you... I will post it as soon as I complete..