Thread: How to bring data from one page into another page with the conditional formatting copying across
View Single Post
 
Old 07-23-2018, 12:51 PM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
I think you just need to adjust your conditional formats to use a formula instead...


e.g.


For the red colour, instead of selecting "Format only Cell that Contains", select "use a formula to determine....."


Then apply formula:



=AND(D4>0,TRIM(D4)<>"")
Reply With Quote