We help IT Professionals succeed at work.

Excel automatic formatting

ltpitt
ltpitt asked
on
289 Views
Last Modified: 2014-11-26
Hi all!

I've prepared a formula that colors my cell following various rules

Everything works great but if I copy the formula for all the column it won't work for all the rows...

I need this formula to work on both Excel and Libre Office Calc.

What am I doing wrong?

See example attached.
test.xlsx
Comment
Watch Question

Darrell PorterEnterprise Business Process Architect
CERTIFIED EXPERT

Commented:
I opened your attached file and saw no conditional formatting and no VBA (opened Visual Basic Editor from the Developer tab.

Please save your working example as a Macro-enabled Excel workbook (XLSM extension).
Excel VBA Developer
CERTIFIED EXPERT
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
That's what a perfect solution should be!

Thanks :D
Glenn RayExcel VBA Developer
CERTIFIED EXPERT
Top Expert 2014

Commented:
You're welcome.  Happy Thanksgiving!
-Glenn
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.