Help with conditional formula using color (watch video)

%3CLINGO-SUB%20id%3D%22lingo-sub-2830052%22%20slang%3D%22en-US%22%3EHelp%20with%20conditional%20formula%20using%20color%20(watch%20video)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2830052%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%3C%2FP%3E%3CP%3EI'm%20in%20need%20of%20assistance%20with%20a%20conditional%20formula%20using%20colors%20please.%3C%2FP%3E%3CP%3EHere%20is%20a%20brief%20video%20showing%20what%20I'm%20wanting%20to%20do.%3CBR%20%2F%3E%5Burl%5D%3CA%20href%3D%22https%3A%2F%2Fscreencast-o-matic.com%2Fwatch%2Fcr6QD9VXr2u%5B%2Furl%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fscreencast-o-matic.com%2Fwatch%2Fcr6QD9VXr2u%5B%2Furl%3C%2FA%3E%5D%3C%2FP%3E%3CP%3EHere%20is%20that%20sample%20excel%20worksheet%20used%20in%20the%20video.%3CBR%20%2F%3E%5Burl%5D%3CA%20href%3D%22https%3A%2F%2Fu.pcloud.link%2Fpublink%2Fshow%3Fcode%3DXZTka6XZldQXXAdDJC7FlsaobNCoq7N2xS6k%5B%2Furl%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fu.pcloud.link%2Fpublink%2Fshow%3Fcode%3DXZTka6XZldQXXAdDJC7FlsaobNCoq7N2xS6k%5B%2Furl%3C%2FA%3E%5D%3C%2FP%3E%3CP%3EI'd%20really%20appreciate%20if%20you%20could%20help%20me%20with%20this.%3CBR%20%2F%3EThank%20you!%3C%2FP%3E%3CP%3ERon%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2830052%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2830399%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20conditional%20formula%20using%20color%20(watch%20video)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2830399%22%20slang%3D%22en-US%22%3Elinks%20are%20invalid%20is%20this%20spam%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello.

I'm in need of assistance with a conditional formula using colors please.

Here is a brief video showing what I'm wanting to do.
[url]https://screencast-o-matic.com/watch/cr6QD9VXr2u[/url]

Here is that sample excel worksheet used in the video.
[url]https://u.pcloud.link/publink/show?code=XZTka6XZldQXXAdDJC7FlsaobNCoq7N2xS6k[/url]

I'd really appreciate if you could help me with this.
Thank you!

Ron

4 Replies
links are invalid is this spam?

@Yea_So 

 

No sir, this is not spam.

 

Here are those links again.

Here is a brief video showing what I'm wanting to do.
https://screencast-o-matic.com/watch/cr6QD9VXr2u

Here is that sample excel worksheet used in the video.
https://u.pcloud.link/publink/show?code=XZTka6XZldQXXAdDJC7FlsaobNCoq7N2xS6k

@rjparkerjr 

 

excel cannot return a color value using formulas other than conditional formulas.

i.e If this cell is grey then put grey here. It can only do if this value in this cell is greater than x then color it grey (it has to be true, but there is no formula in excel that can evaluate color except text color and only red to indicate if the number is negative or not.

 

see: CELL() function

How to use the Excel CELL function | Exceljet

That is the only formula function that can evaluate text color to indicate if a number is positive or negative.

 

What you want can only be done in vba macro

 

tag your post with vba.

Thank you very for your insights.