> than < than change cell to red (MS Excel)

Afternoon all. Ok, I have a daily sales column 'J4' and a stock figure in 'H4' If the daily sales is lower than the stock figure. I want the cell to change to red. There will be a second part to this question, but I need to do one step at a time. Many thanks for your help all. Lee.
helponaccessAsked:
Who is Participating?
 
softplusConnect With a Mentor Commented:
I don't have the english Excel, but I'll try (with help of the above link for the english terms) :)
To add conditional formatting to a cell select the cell you want to format.
Choose the menu Format->Conditional Formatting...
Change the dropdown from "Cell Value Is" to "Formula Is" and enter the formula (i.e. J4<H4).
Click "Format" and then the Pattern tab. Choose a color. You can add multiple conditions for the same cell by clicking the Add>>. Each condition can have a unique format. Click OK and OK again.

Does that work?
John
0
 
softplusCommented:
0
 
helponaccessAuthor Commented:
Thanks Softplus.

I am pretty thick when it comes to this stuff. (still learning). So please bare with me.
I have had a look at the above link, and i am still none the wiser.

Could you make the answer as simple as possible?

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.