Conditional Format

[Pinaceous]

Good Day Everyone!

Wanted to provide a CF for cell G11 to turn an interior red if and only if, if a value is entered into its row between H11: AJ11, when G11 is blank.


Currently I have:

View attachment 116911



Would like to see this CF applied here:
View attachment 116912

Also, I'd like for the CF of G11 from the interior red cell to go away when a value has been entered into its interior cell red, as in:


View attachment 116913





Please let me know!

Thank you!
pinaceous

 

[Pinaceous]

Yes, it can:

Book1
	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ
11								1
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G11	Expression	=AND(ISBLANK(G11),COUNTA($H$11:$AJ$11)>=1)	text	NO

View attachment 116975View attachment 116976

Thank you! Let me plug it in and try it out!

 

[Alex Blakenburg]

Another option is "" is a possibility in either G11 or H11:AJ11 but considered to be blank.

=AND(G11="",COUNTIFS(H11:AJ11,"")<>COLUMNS(H11:AJ11))

 

[Pinaceous]

Another option is "" is a possibility in either G11 or H11:AJ11 but considered to be blank.

=AND(G11="",COUNTIFS(H11:AJ11,"")<>COLUMNS(H11:AJ11))

Hey Alex Blakenburg,

Out of all of the codes thus far, this one is really, really close!

However, in your code I expected the cell of G11 to turn an interior red color, when an entry has been made/entered into the range of H11:AJ11, when G11 is blank.

As in:

Please let me know!

Thank you!

Pinaceous

 

[Sergius]

The code from Alex Blakenburg is working. Maybe you entered something wrong.

Book1.xlsm
	A	B	C	D	E	F	G	H	I	J
11	1									1
12	2
13	3
14	4
15	5
16	6
17	7
Sheet5

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G11	Expression	=AND(G11="";COUNTIFS(H11:AJ11;"")<>COLUMNS(H11:AJ11))	text	NO

Book1.xlsm
	A	B	C	D	E	F	G	H	I	J
11	1						5			1
12	2
13	3
14	4
15	5
16	6
17	7
Sheet5

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G11	Expression	=AND(G11="";COUNTIFS(H11:AJ11;"")<>COLUMNS(H11:AJ11))	text	NO

 

[Pinaceous]

Hi *Sergius!

Thank you so much for your posting!

Yes, it did work and I'm marking post#12 as a solution

I did not realize that the range was G11 where, I was putting H11:AJ11.

 

[Pinaceous]

Hi *Sergius!

The only issue I see now is that G11 provides an interior red cell when a value is entered into it.



Can you please provide that if a value is entered into G11 that if it has an interior red cell in it that it will disappear?



Here is a screenshot of G11’s interior red cell:

Please let me know!



Thank you!

pinaceous

 

[MARK858]

@Pinaceous are you sure that you haven't manually formatted G11 as red?

 

[Asbestos_Jen]

Showing us what you're using in the conditional formatting screens is more useful than showing us a cell coloured red. Can you take screenshots like the ones I had in post #10? Also the formulas you're using in G11 and/or H11 if any.

 

[Sergius]

Hello Pinaceous!
If you look closely at the conditional formatting formula for cell G11, you will see that everything works as you intended in your first post.

for cell G11 to turn an interior red if and only if, if a value is entered into its row between H11: AJ11, when G11 is blank

G11 from the interior red cell to go away when a value has been entered into its interior cell red

Confirmation that it works as you intended, post #14

 

[Pinaceous]

Good Day,

What exactly is the meaning of :

Selection.FormatConditions(1).StopIfTrue = False

in the Conditional Formatting formula?


Please let me know.

Thank you!
pinaceous