NWPhotoExplorer
New Member
- Joined
- Jan 19, 2021
- Messages
- 34
- Office Version
- 365
- Platform
- Windows
- MacOS
I'm working on a sheet that I use to keep track of my time worked and make sure it matches my paycheck. I have a few fields that have different headers, based on the type of payment received. I am trying to figure out how to write a conditional formatting formula that will look at the header title and then go to a specific field and see how many hours were there and match it to what was entered of the paycheck. It will color code it RED if I was shorted and GREEN if it matches.
As I am new to excel, I am still learning which functions to use and when, so I am not really sure what I should use here. Basically, I want to say if header Z1 = ABC PAY, look in J2 and if the value in Z2 matches J2, color it green, if not red. But I don't know how to go about setting that up in a conditional format. I am hoping someone here can help me get this to work correctly.
Thanks!
As I am new to excel, I am still learning which functions to use and when, so I am not really sure what I should use here. Basically, I want to say if header Z1 = ABC PAY, look in J2 and if the value in Z2 matches J2, color it green, if not red. But I don't know how to go about setting that up in a conditional format. I am hoping someone here can help me get this to work correctly.
Thanks!