If formatting

		Microsoft Office Forums > Microsoft Excel > Excel
If formatting

FAQ

Thread Tools

Display Modes

09-16-2014, 07:27 AM

Pecoflyer

Windows 7 64bit If formatting

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

=if(a1=b1,0,if(a1>b1,1,2))

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

09-17-2014, 12:58 AM

clara1703

Windows 7 32bit If formatting

Office 2010 32bit

Novice

Join Date: Sep 2014

Posts: 2

If formatting - Many Thanks

Thank you so much for your help, it does exactly what I want it to do.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and Replace, Formatting, Formatting Formula	kjxavier	Word	1	07-04-2014 09:11 AM
Conditional formatting that ignores other formatting rules	info_guy2	Excel	1	07-03-2014 10:07 AM
Formatting contents after Tab of continuous lines or formatting specific area of word	pawii	Word	1	05-12-2014 05:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:55 AM.