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

 

[arthurz11]

I'll give this a shot. Select the cell G11 and then select CF. Format fill color red. Write formula =IF(AND(H11:AJ11 >= 0,G11=""),1,0)

 

[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:

Would like to see this CF applied here:

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:

Likewise, if nothing is entered then:

Please let me know!

Thank you!
pinaceous

 

[Pinaceous]

I'll give this a shot. Select the cell G11 and then select CF. Format fill color red. Write formula =IF(AND(H11:AJ11 >= 0,G11=""),1,0)

Hi arthurz11,

It did not work for me....


What range should I apply it to?

Please let me know,

Thank you!
pinaceous

 

[arthurz11]

Hi arthurz11,

It did not work for me....


What range should I apply it to?

Please let me know,

Thank you!
pinaceous

On Post #3. You wrote range A11:AJ11. Is this correct?

 

[arthurz11]

I wrote two samples of Conditional Formatting formulas. One in cell G1 and the other in cell G2. Hopefully, this is what you're looking for?

 

[Pinaceous]

I wrote two samples of Conditional Formatting formulas. One in cell G1 and the other in cell G2. Hopefully, this is what you're looking for?

View attachment 116924

Hi arthurz11,

Using the formulas you supplied =

And here:

This is what I get:

This is not right because it automatically highlights an interior red from H11:AJ11.

I would like G11 to be highlighted with an interior red when an entry has been made in the H11:AJ11 range if G11 is blank.

Does this make more sense?

Please let me know.

Thank you!
Pinaceous

 

[Asbestos_Jen]

Assuming that G11 is actually blank, and not a null string, try this in conditional formatting for G11:

=AND(ISBLANK(G11),COUNTA(H11:AJ11)>=1)

If G11 is a null string, change

ISBLANK(G11)

to

G11=""

 

[Pinaceous]

Assuming that G11 is actually blank, and not a null string, try this in conditional formatting for G11:

=AND(ISBLANK(G11),COUNTA(H11:AJ11)>=1)

If G11 is a null string, change

ISBLANK(G11)

to

G11=""

Hello Asbestos_Jen,

Thank you for posting! Do you know if this can be applied to a CF?

Please let me know.

Thank you!

pinaceous

 

[Asbestos_Jen]

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