• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 206
  • Last Modified:

> 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.
0
helponaccess
Asked:
helponaccess
  • 2
1 Solution
 
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
 
softplusCommented:
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now