Previous Topic Next Topic

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

Answer 1 / 2
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
Answer 2 / 2
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response