Conditional formating

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional formating

FAQ

Thread Tools

Display Modes

#10

12-01-2016, 10:58 AM

MJS16

Windows 7 64bit Conditional formating

Office 2016

Novice

Join Date: Dec 2016

Posts: 9

this is the bit thats confussing me. When i chose conditional format by formula and input (=LEFT(H4,FIND("/",H4)-1)+RIGHT(H4,LEN(H4)-FIND("/",H4))>$D4) as the criteria , when i change which cells it applies to ( columns H:AL) all cells are looking to H4 for the result?

Tags

concatenated data

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formating	MaineLady	Excel	2	10-30-2016 02:08 PM
Conditional Formating	Aseren	Excel	14	02-18-2016 01:05 PM
Copying Conditional Formating	lynette	Excel	2	03-06-2015 11:53 AM
Conditional Formating	MaineLady	Excel	1	11-05-2014 06:37 PM
more Conditional Formating	princeofsadness	Excel	2	09-05-2011 02:14 AM

Other Forums: Access Forums

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