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

 

[MARK858]

It means if that condition is met then continue to check other conditions, it is the equivalent of leaving the stop = true box unchecked when applying a conditional format manually

 

[Pinaceous]

It means if that condition is met then continue to check other conditions, it is the equivalent of leaving the stop = true box unchecked when applying a conditional format manually

View attachment 117819

Thank you so much!