Conditional Formatting based on cell value, not cell formula

[Mike Thoreson]

Hi - I'm trying to set up conditional formatting on a cell based on a comparison of values in two other cells. The problem I'm running into is the values in the comparative cells are derived from formulas in those cells. Is there a way to conditionally format based on the returned values and not the formulas themselves?

 

[davesexcel]

Conditional formatting is based on values not the formulas themselves.

Can you show an example of what you mean.

 

[Mike Thoreson]

Conditional formatting is based on values not the formulas themselves.

Can you show an example of what you mean.

 

[Mike Thoreson]

I couldn't find a way to attach the file so hopefully this will work. Below is a screenshot of the information I'm working with. I want to highlight the driver name (column A) if the vehicle ID (Column D) is the same as the PTO vehicle ID (column O).

- The Driver Name imports from another tab called Driver Table
- The Vehicle ID is based on an Xlookup matching the driver name to a vehicle number in another tab called Trip History Report
- The PTO vehicle is based on an Xlookup matching the vehicle ID to a vehicle number in a different tab called PTO Vehicles

Where I want to get to is to highlight the name of the driver if that driver is operating a vehicle with a PTO. For example, on row 4 I want to highlight Adam Johnson in red text because he's driving vehicle 3562-P01, which happens to have a PTO. I've tried several different formulas in conditional formatting but nothing has worked - the only commonality I can think of is the cells are formulas returning values.

As an aside, the data in the Consolidated tab is driving a pivot table (the Summary tab) and I ultimately want to get that highlighting in the pivot table.

 

[davesexcel]

Check out the xl2bb add-in to get sample in your thread.

 

[Mike Thoreson]

Our IT won't allow 3rd party plugins.