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

NBVC · #1 07-23-2018, 12:51 PM

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)<>"")

tabitha · #2 07-24-2018, 12:35 AM

Thank you for this formula. It has worked on the first page perfectly, but the other two seem to be colouring in the boxes 4 down. Do I need to modify the formula? I have attached the sheet so you can see.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting for non-alphabetic data	dbbath	Excel	3	07-25-2017 05:09 AM
Copying values that have conditional formatting applied	Cosmo	Excel	10	02-24-2017 06:27 AM
How do I bring up a new page	Nikilet	Excel	6	02-03-2017 08:19 AM
Book formatting: need to alternate page number on left and right margin for only first page of each	author_mshane	Word	7	06-15-2016 09:04 AM
MS Word, page goes to next page when entering data on previous page	munna94	Word	2	12-30-2010 08:12 AM