conditional formatting not working.

[jbrown021286]

I am attempting to apply conditional formatting to adjacent cells in a table but for some reason it is not working correctly. column c will not react at all and column a is the only one that resounds correctly b and d just stay formatted when cell e is empty. when i try to apply the same formula down the table i will get random cells in different columns not formatting. i also tried the formula =NOT(ISBLANK(E2)) with the same result. any advice would be appreciated.

 

[Georgiboy]

Have you tried putting a $ before the E of E2 making it $E2?

 

[etaf]

you are only applying to row 2 ...

countif(E2,"<>") should conditional format if E is NOT blank

as you are selecting A to D you need a $

countif($E2,"<>")

Book1
	A	B	C	D	E
1
2
3
4
5
6					1
7
8
9					1
10
11
12					1
13
14
15
16
17
18
19
20
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:D20	Expression	=COUNTIF($E2,"<>")	text	NO

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A2:D100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
countif($E2,"<>")

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

 

[kevin9999]

Try changing your formula to:

=$E2<>""