Link to home
Start Free TrialLog in
Avatar of ltpitt
ltpitt

asked on

Excel automatic formatting

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
Avatar of Darrell Porter
Darrell Porter
Flag of United States of America image

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).
ASKER CERTIFIED SOLUTION
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ltpitt
ltpitt

ASKER

That's what a perfect solution should be!

Thanks :D
You're welcome.  Happy Thanksgiving!
-Glenn