# Software

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

## Question

Locked

### Excel (Conditional Formatting)

By ·
I need 1 cell to populate from other cells based on criteria.

If cell G29 is above 10 to 19.99 then it equals A31
If cell G29 is above 20 to 29.99 then it equals A32
If cell G29 is above 30 to 30.99 then it equals A33
If cell G29 is above 40 to 40.99 then it equals A34
If cell G29 is above 50 to 50.99 then it equals A35
If cell G29 is above 60 and above then it equals A36

Kinda stuck here, any help is much appreciated

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

Collapse -

### Conditional Formatting

by In reply to Excel (Conditional Format ...

Hello,

Why not try this..
"Home" > "Conditional Formatting" > "New Rule"
In "New Formatting Rule" dialog box, click "Format only cells that contain" set value to 10 - 19.99 then click on "Format" then choose "Font style" and "Color". Click on Ok for both dialogs then create another for 20 - 29.99/30 - 39.99 and so on.. By the way, set it to different color so you can see the difference.

Collapse -

### Conditional formatting, or "IF" formula?

by In reply to Excel (Conditional Format ...

Sounds like you want to return the values in the range from A31:A36 depending on the value in G29.

I don't think that is conditional formatting you want? You could try this nested "IF" formula. Paste it into the cell where you want the appropriate value to appear.

=IF(G29>60,A36,IF(G29>50,A35,IF(G29>40,A34,IF(G29>30,A33,IF(G29>20,A32,IF(G29>10,A31,A31))))))

## Related Discussions

• 5

#### What are the best Real Estate Marketing Automation Tools?

nehaagarwalceo ·

• 2

#### What is best to use between pardot and cloud for marketing automation

1409devanshu ·

• 6

Nora.Oz ·

• 6

#### Accounting software

beverleycosgrove59 ·

• 1

#### Software for generating invoices

Michael_Schumacher ·