Conditional formatting not working with simple formula

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional formatting not working with simple formula

11-17-2016, 11:31 AM

bendmc

Windows 7 64bit Conditional formatting not working with simple formula

Office 2013

Novice

Join Date: Nov 2016

Posts: 2

Fixed it. The rule has to start at the top of the area applied to so its $H1 not $H2>7. This slides down the formatting one row for some reason.

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Indirect not working in Conditional Formatting	tinfanide	Excel	11	06-21-2016 04:55 PM
Need conditional formatting formula	namedujour	Excel	1	05-27-2016 08:58 AM
Conditional Formatting Formula	teza2k06	Excel	1	08-22-2014 02:49 AM
Formula/Conditional Formatting	teza2k06	Excel	1	04-15-2014 06:49 PM
conditional formatting formula	NEHicks503	Excel	1	11-30-2011 09:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:20 PM.