HELP HELP HELP Excel Formula

Closed
PD - Jan 26, 2015 at 01:07 PM
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Jan 27, 2015 at 10:58 PM
Hello,
I really need help trying to figure out this formula, as I have tried so many different formulas and can't seem to find one that works. I need a formula in where, In "Column F" If it says "Approved" and there is no numeric value in Column E, the cell in Column E turns yellow. Please help! Thanks!



2 responses

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Jan 26, 2015 at 02:39 PM
I would love to see what you have tried.
In the meantime, using Conditional formatting:

1
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 1
Jan 27, 2015 at 10:58 PM
Rays is right as always
0