Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News Editorials & Other Articles General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

Computer Help and Support

OAITW r.2.0

(29,169 posts) Sun Apr 3, 2022, 03:44 PM Apr 2022

Excel question - help with formula. [View all]

I used this a few years ago, but have forgotten the formula.

Here's what I want to do-

if the calculated cell returns a pos#, turn font color green, if negative, return font collar read.

If you happen to have the formula, a cut and paste in reply - that would be greatly appreciated.

14 replies

= new reply since forum marked as read

Highlight:

Excel question - help with formula. [View all] OAITW r.2.0 Apr 2022 OP

Format is the way Tetrachloride Apr 2022 #1

Perfect answer! OAITW r.2.0 Apr 2022 #2

My char name is a word play has lost relevance. But i kept it anyway Tetrachloride Apr 2022 #7

My grandma always had a big bottle carbon tetrachloride in her laundry room... hunter Apr 2022 #13

I have a related question if anyone happens to know intrepidity Apr 2022 #3

Look at link MacKasey Apr 2022 #8

It all comes rushing back intrepidity Apr 2022 #10

Sorry, duplicate post. Hoyt Apr 2022 #4

I forget formulas too. I usually end up sorting on the result and changing the font color. Hoyt Apr 2022 #5

Oh worlds are colliding underpants Apr 2022 #6

Don't consider myself a power user by any stretch, but I got hooked on LOTUS 1-2-3 OAITW r.2.0 Apr 2022 #9

Don't play God with DU underpants Apr 2022 #11

I'd subscribe intrepidity Apr 2022 #12

Conditional formatting canetoad Apr 2022 #14