Conditional Formatting a column

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional Formatting a column

01-27-2017, 01:05 PM

Washbue1

Windows 10 Conditional Formatting a column

Office 2010 32bit

Novice

Join Date: Jan 2017

Posts: 2

Quote:

Originally Posted by jeffreybrown

Highlight your range H2:H100

Create a new rule with =I2 < H2

I created the rule, after selection the range, and it still didn't format correctly to turn red.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting	grexcelman	Excel	8	01-12-2015 10:27 AM
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N	mikey386	Excel	2	12-11-2014 01:14 PM
Conditional formatting that ignores other formatting rules	info_guy2	Excel	1	07-03-2014 10:07 AM
Conditional Formatting	teza2k06	Excel	3	01-19-2014 02:34 AM
Creating multiple conditional rules on one column	secoo140	Excel	0	10-07-2013 12:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:21 AM.