If/Then Conditional Formatting in Excel

[dmlynn]

Hi!

Could someone please let me know if this is possible?

I have two columns, A (category) & B (issue), that contain data in a list format in each cell.
I would like to say if an issue is selected in B1, then A1 cell would get populated with its corresponding category match.

 

[Joe4]

Welcome to the Board!

I don't think you want Conditional Formatting - Conditional Formatting only changes the formatting of cells, not their values.
I think you meant to say a Conditional Formula.

So I think you want a formula in cell A1 that is structured something like:
=IF(B1<>"",...)

If you want to lookup a value from a table, then you would use something like a VLOOKUP, XLOOKUP, or INDEX/MATCH formula embedded within that IF statements.
Here are some details on VLOOKUP: MS Excel: How to use the VLOOKUP Function (WS)

If you need more help, please provide more details and show us an actual example.