IF function

[Tashia]

Hello,
Please help me write an IFformula:

Cell B1 must equal A1. If not, return a red border around cell B1.

Thank you in advance.

[DGagnon]

that would be done with conditional formating, use the formula

=B1<>A1

in your conditional format, then set a red border.

[Tashia]

Sorry the solution did not work. I've attached a sample spreadsheet. Thank you.

[DGagnon]

What cells are you trying to compare? Cell A1 = "Pay Period" and Cell B1 = "Start" as these are text, i don't suspect this is the cells you meant.

[Tashia]

in the attached spreadsheet I am trying to compare total hours worked and total hours paid.

shade total hours paid red if it does not equal total hours worked

thank you

[Leviathan62089]

Alright, I went ahead and did the conditional formatting.

All you have to do in the real version is add a conditional formatting rule to the "total hours paid" cells using the rule type "Use a formula to determine which cells to format". Then use the formula "= (total hours paid cell) <> (total hours worked cell)" ie... =V8<>I8. Then set the format to a red border, red highlight, or whatever you want when the result is true.

[Tashia]

Thank you this worked

[DGagnon]

no problem,

could you please mark this thread as solved? To do so, go to thread options at the top, and select mark as solved.