Conditional Formatting Filling

ssblue
ssblue used Ask the Experts™
on
Excel Conditional Formatting
I have two worksheets ( Sheet1 and Sheet2) and I want to fill Sheet2 with highlighted cells based on Sheet1.
Example - If cells in columns A thru D have anything in them on Sheet1 - then highlight the same cells on sheet2
ConditionalFilling.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
For that, select a range on Sheet2, say A1:D1000 and make a new rule for conditional formatting using the formula given below and set the format as per your choice.

=Sheet1!A1<>""

Open in new window

ConditionalFilling.xlsx
ssblueCoordinator

Author

Commented:
Thanks
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
Welcome and Happy New Year! :)
ssblueCoordinator

Author

Commented:
Happy New Year to You also!  Thanks again! :)
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
Thanks! :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial