Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
In excel, how do I write a formula that says,?
"If E5 is not blank, then E6 must also not be blank, if true then no action, if false format E5 red."
1 Answer
- braydenLv 79 years agoFavorite Answer
Do it using conditional formatting.
Here's how I did it:
First click inside Cell E5
Then--
- From the home tab, click the 'conditional formatting'
- Select new rule
- Select 'use a formula to determine which cells to format'
- In the box that says "Format values where this formula is true" I put this into the box:
=AND(E5>0,E6>0)
Then click the "format" button and select the color of red you prefer
Click OK to come back out of this
To test it, put a number in cell E5. It should not change color to red. Now put a number in Cell E6. Now E5 should turn red. Because both cells have to have a number in them for the conditional formatting to work.
