Exel

%3CLINGO-SUB%20id%3D%22lingo-sub-1034504%22%20slang%3D%22en-US%22%3EExel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1034504%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20that%20includes%20two%20currency%20columns.%20These%20columns(say%20Q%20and%20R)%20are%20derived%20from%20other%20columns%20based%20on%20my%20formula.%20Values%20would%20be%20null%2C%20positive%20or%20negative.%20How%20do%20I%20change%20entire%20row%20color%20based%20on%20combined%20value%20of%20Q%2BR%3F%20If%20Q%2BR%20is%20positive%2C%20entire%20row%20should%20be%20GREEN.%20If%20Q%2BR%20is%20negative%2C%20entire%20row%20should%20be%20RED.%20If%20both%20Q%20and%20R%20are%20null%2C%20no%20row%20color%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1034504%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
ss2destiny
Occasional Visitor

I have a spreadsheet that includes two currency columns. These columns(say Q and R) are derived from other columns based on my formula. Values would be null, positive or negative. How do I change entire row color based on combined value of Q+R? If Q+R is positive, entire row should be GREEN. If Q+R is negative, entire row should be RED. If both Q and R are null, no row color

1 Reply

@ss2destiny 

 

Have you tried using "Highlight Cells Rules"??

 

It's on the Home Tab, under "Conditional Formatting"

Related Conversations
Excel Text Validation Help
TimothyE in Excel on
5 Replies
Macro to inserting Picture
Tsengee in Excel on
0 Replies