ExcelBanter - Conditional Formating

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Conditional Formating (https://www.excelbanter.com/excel-programming/412329-conditional-formating.html)

Albert Mulder

Conditional Formating

I need to check to see if

E36:K44 = "X"

and if so change formating.

What is the formula to check the cells for an "X"

I used this to check if there is a "1"
=COUNTIF(E26:K26,1)0

All times are GMT +1. The time now is 10:23 AM.