**Question description:**

*This user has given permission to use the problem statement for this blog.*

I have a volume cell & a price cell & i need a conditional formatting to highlight the price cell in red, if there is a value in the volume cell & no value in the price cell

Solved by D. D. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
26/08/2018 - 09:47

Hello! How are you?

User
26/08/2018 - 09:48

18

Excelchat Expert
26/08/2018 - 09:48

Is it possible to show me a sample of your data in the Document Preview on the right?

User
26/08/2018 - 09:50

i'd like cell h5 to light up in red

User
26/08/2018 - 09:50

cause i have a volume number with no price

Excelchat Expert
26/08/2018 - 09:50

Same with J5 right?

User
26/08/2018 - 09:50

yes

User
26/08/2018 - 09:51

i know i should use if & and

User
26/08/2018 - 09:51

but not sure how to write that

Excelchat Expert
26/08/2018 - 09:51

The same condition applies continuously down the rows

User
26/08/2018 - 09:51

yes

Excelchat Expert
26/08/2018 - 09:51

Okay.. One moment

Excelchat Expert
26/08/2018 - 09:53

Done... Could you please try to add dummy day up to row 13 and check if it works

User
26/08/2018 - 09:54

great!

Excelchat Expert
26/08/2018 - 09:54

Cool

Excelchat Expert
26/08/2018 - 09:54

You are using Excel, right?

User
26/08/2018 - 09:54

yes

Excelchat Expert
26/08/2018 - 09:55

So to do this, first you need to highlight the range (or set of cells) pertaining to Price

Excelchat Expert
26/08/2018 - 09:55

in our example here - I applied it cells H4:K13

Excelchat Expert
26/08/2018 - 09:56

Hi? You still with me?

User
26/08/2018 - 09:56

yes following

Excelchat Expert
26/08/2018 - 09:56

Then you go to Home>Conditional Formatting>New Rule

User
26/08/2018 - 09:56

ok

Excelchat Expert
26/08/2018 - 09:57

Under Select Rule Type > Use a formula...

User
26/08/2018 - 09:57

ok

Excelchat Expert
26/08/2018 - 09:58

Then in the formula bar type in =AND(first cell in your price range (e.g. H4)="",corresponding first cell in your volume range (e.g. C4)<>"")

Excelchat Expert
26/08/2018 - 09:59

=AND(H4="",C4<>"")

Excelchat Expert
26/08/2018 - 09:59

This is what I typed in our example

Excelchat Expert
26/08/2018 - 09:59

Then click the Format Button, and select the preferred formatting when the condition is met

Excelchat Expert
26/08/2018 - 10:00

In our example, fill is Red

User
26/08/2018 - 10:00

done

Excelchat Expert
26/08/2018 - 10:00

Then press OK

User
26/08/2018 - 10:00

i tried & it worked with me

User
26/08/2018 - 10:00

cant thank u enough

Excelchat Expert
26/08/2018 - 10:00

Happy to hear that :)

Excelchat Expert
26/08/2018 - 10:00

You may now end the session any time

Excelchat Expert
26/08/2018 - 10:00

Appreciate if you could leave good feedback and rating after the session

Excelchat Expert
26/08/2018 - 10:01

To end the session, press the END SESSION button on the upper right corner of the window

Excelchat Expert
26/08/2018 - 10:01

beside the countdown timer

Excelchat Expert
26/08/2018 - 10:01

Thanks and have a great day! :)

Excelchat Expert
26/08/2018 - 10:02

Hello? Are you still with me?

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*