Conditional formatting not working with simple formula

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

FAQ

Thread Tools

Display Modes

11-17-2016, 10:28 AM

Pecoflyer

Windows 7 64bit Conditional formatting not working with simple formula

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,955

Pecoflyer has a reputation beyond repute

Could you please post a sample sheet
Perhaps try =$a$2:$I50000 as range to apply to but starting in row 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

Tags

conditional formatting, highlight cells, rules

« Previous Thread | Next Thread »

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 08:00 PM.