conditional formatting help (solved)

[david gabra]

Hi

I was aked to put this in a new threwad.

Are you able to put those cool excel skill to help me on tab: Testing_Main - cell B10
I want the cell to turn red if the cell is empty and cell P10 is empty.
One you fix this I will need to do this all on cells from B10 to p10 - unles you have a quick fix for that.
thanks

David.

 

[pecoflyer]

1. First get rid of the existing circular references
2

I want the cell to turn red if the cell is empty and cell P10 is empty.
One you fix this I will need to do this all on cells from B10 to p10

This will create a new circular reference in P10

 

[david gabra]

1. First get rid of the existing circular references
2

This will create a new circular reference in P10

Please, I do not undestand.
I don't see where I have them. don't know what they are and don't know why it prevents .

Please can somone help me on tihs.

I have worked so so long on this excel and I so near the end and I don't understand how to proceed with the excel attached above.

 

[david gabra]

My bad. - Seee updated typo error.

-I want the cell to turn red if the cell is empty and cell Q10 is empty. I added P10, it shoud be Q10.

Hi

I was aked to put this in a new threwad.

Are you able to put those cool excel skill to help me on tab: Testing_Main - cell B10
I want the cell to turn red if the cell is empty and cell Q10 is empty.
One you fix this I will need to do this all on cells from B10 to p10 - unles you have a quick fix for that.
thanks

David.

 

[vletm]

david gabra
You asked a solution for something like below:
Applies to: $B$10:$B$109
Rule: =AND(B10="",Q10="")
... but is it something which You thought to ask?
... because You had there (B10's conditional formatting) something ... else

 

[david gabra]

I am sorry if i am confusing. I would like to have the case where a cell (B10) will be coloured red if it is empty and if the q10 is NOT blank.
Is please possible to add to excel since I do not understand the above.
thanks for the time and effort.


sorrry!!!!!!!

 

[david gabra]

fixed it - due to the help above - changed formulae to =AND(B10="",Q10<>"")

Thanks all!!!!!!!

 

[david gabra]

Is there is a quick way if if I want to do for all cells in the range from AND(B10="",Q10<>"")
at the b10 wil be for all cells from b10 to p100 and the q10 will be for all cells from q10 to 100.
if not I will do one by one.

 

[ETAF]

you asked in the other thread to extend to P10

if so then
slight change to the formula - so Q is fixed
=AND(B10="",$Q10<>"")

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

Highlight applicable range >>
B10 : P10 - 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:
=AND(B10="",$Q10<>"")

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

all in 1 go

if you want to do more rows
then
same formula
But select the rows to apply
B10 : P100000 or how many rows to apply to

all in 1 go

so dont have to do each cell

 

[david gabra]

GENUIS!!!! thank you - - you saved me doing one by one.... what a relief.

 

[david gabra]

this post is closed now

 

[ETAF]

you are welcome

 

[vletm]

david gabra
#1 reply - I want the cell to turn red if the cell is empty and cell P10 is empty.
#4 reply - I want the cell to turn red if the cell is empty and cell Q10 is empty.


#6 reply - I would like to have the case where a cell (B10) will be coloured red if it is empty and if the q10 is NOT blank.
>>> You had three different variations ... maybe You got finally - what did You think, but You asked something else ... ?
Take care