Microsoft Office Forums - View Single Post - How to bring data from one page into another page with the conditional formatting copying across

Thread: How to bring data from one page into another page with the conditional formatting copying across

View Single Post

Old

07-24-2018, 11:45 AM

NBVC

NBVC is offline

NBVC uses Windows 10

Windows 10 NBVC uses Office 2013

NBVC uses Office 2013

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

NBVC will become famous soon enough

NBVC will become famous soon enough

Default

You need to adjust the formula to the top left most cell of the range that you are applying the condition to... so probably:

=AND(D8>0,TRIM(D8)<>"")

Reply With Quote