UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Conditional Formatting, Office 2013    
 
   
wantj43
post Aug 8 2019, 12:44 PM
Post#1



Posts: 55
Joined: 8-May 13
From: Fairbanks Alaska


Good morning,
If the value of a cell in column "b" is greater than the corresponding row cell value in column "a" I need the cell in column "b" to be formatted to a color.
However, if the cell value in column "a" is zero I do not want the formatting applied. With the targeted cells selected the formula "=B2>A2" highlights the cells meeting the criteria including "zeros" which I am trying to exclude from the formatting.
Any help greatly appreciated.
Thank you.
Joe
Go to the top of the page
 
GroverParkGeorge
post Aug 8 2019, 05:22 PM
Post#2


UA Admin
Posts: 35,898
Joined: 20-June 02
From: Newcastle, WA


You need to include a second evaluation to see if the value is >0 and concatenate the two evaluations with "AND", so something like this might work:

"=(B2>A2) AND (A2<>0)"

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
GroverParkGeorge
post Aug 8 2019, 06:01 PM
Post#3


UA Admin
Posts: 35,898
Joined: 20-June 02
From: Newcastle, WA


Or maybe this:

=AND(IF(B2>=A2,1),IF(A2<>0,1))

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
Debaser
post Aug 9 2019, 07:25 AM
Post#4



Posts: 147
Joined: 11-October 18



You just need a True/False result, so "=AND(B2>A2,A2<>0)"
Go to the top of the page
 
wantj43
post Aug 9 2019, 12:39 PM
Post#5



Posts: 55
Joined: 8-May 13
From: Fairbanks Alaska


Thanking everyone for their help. Help very much appreciated.
Joe
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    22nd October 2019 - 06:50 PM