Looking to create a conditional statement in excel

0 votes
In Microsoft Excel, I'm attempting to format my cells so that yellow highlights appear if two separate cells are not equal. I want to be able to format the cell so that if someone were to go into the sheet and break the reference to either of those cells, it shows up as highlighted yellow. The cell is referenced to either a Canadian dollar value or an American dollar value (depending on whether the user of the sheet chooses to view the sheet in USD or CAD).

When referencing only one cell, I could achieve this; but, when referencing both, it doesn't work. I attempted to duplicate the rule, but it always appears highlighted in yellow since, when equal to CAD, it is not equal to the USD value, and vice versa.

It would be very appreciated if anyone had any recommendations.
Feb 7, 2023 in Others by Kithuzzz
• 38,010 points
277 views

1 answer to this question.

0 votes

Try using a rule based on a formula and AND. 

I hope this helps you.

answered Feb 7, 2023 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer

How to create a bar graph in Excel 2010 by counts?

Read on usage of pivot charts: Procedure: Pivot Table: Select Data Insert ...READ MORE

answered Oct 21, 2022 in Others by narikkadan
• 63,420 points
416 views
0 votes
1 answer

How to add Conditional Formatting in Excel for a Range of Values

Three distinct rules are required, one for ...READ MORE

answered Oct 24, 2022 in Others by narikkadan
• 63,420 points
715 views
0 votes
1 answer

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel! ...READ MORE

answered Nov 25, 2022 in Others by narikkadan
• 63,420 points
665 views
0 votes
1 answer

How to create exponential growth in excel over a year

To find an interest rate that will ...READ MORE

answered Dec 24, 2022 in Others by narikkadan
• 63,420 points
267 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,012 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,332 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,670 points
652 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
2,138 views
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,420 points
671 views
0 votes
1 answer

How to create a drop-down list in Excel?

Making a list of the items you ...READ MORE

answered Oct 9, 2022 in Others by narikkadan
• 63,420 points
388 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP