HELP HELP HELP Excel Formula [Closed]

Report
-
ArashMan
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
-
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 replies

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
I would love to see what you have tried.
In the meantime, using Conditional formatting:

1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3984 users have said thank you to us this month

Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
Rays is right as always