nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

Conditional formatting in a single cell based on "IF" formula

kyletds

I have a simple function I'd like to use. IF cell A2 is greater than cell A1, then format the background of the cell green. If cell A2 is less than cell A1, then format the background of the cell red.

Can this be done? Please help and thanks.

Find more posts tagged with

Conditional Formatting

Comments

Mike Wilday

Yes. You will want to use conditional formatting. See the screenshot below. You will need to set a rule for red formatting and a separate rule for green formatting.

Sign in to join the conversation!

Quick Links

Trending discussions

Can no longer edit Smartsheet that I own.
This just started today… For some reason, I can no longer edit fields in my Smartsheet. One I'm the owner of. I do see an icon in the upper right that says "Comment Only", but can't figure out how to change it. Here a screenshot of what I am seeing:
Can your recover accidental data
Hello , I have a group of cells that have been deleted by accident with saved attachments . all bulk deleted from the same sheet. Is there any way to recover them ?
Understanding Group Membership vs Sheet Permissions
Hi Community, I'm trying to understand how group memberships affect editing permissions within Smartsheet. We have two users who are unable to edit project sheets. When I checked their group memberships, I found that they are associated with the following groups: Technical Resources CS Tracker Editor+Share In the…