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
LVL 1
ltpittAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Glenn RayConnect With a Mentor Excel VBA DeveloperCommented:
You only need to change the relative/absolute cell referencing in two of your conditional format formulas.

First, open the Conditional Formatting Rules Manager (Menu: Home, Styles group, Conditional Formatting, Manage Rules...)
Change the top filter to "This Worksheet"
CFRMDouble-click the first rule and change the greater than formula to =$H2 and click OK.
CF rule 1Double-click the second rule and change the last formula to =$H2 and click OK.
CF rule 2Your final rule can be left as-is.
Click the "OK" button to close.

You can now copy the cell down as many rows as needed and the conditional formatting rule will follow.

Regards,
-Glenn
0
 
WalkaboutTiggerCommented:
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).
0
 
ltpittAuthor Commented:
That's what a perfect solution should be!

Thanks :D
0
 
Glenn RayExcel VBA DeveloperCommented:
You're welcome.  Happy Thanksgiving!
-Glenn
0
All Courses

From novice to tech pro — start learning today.