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.