Macro to highlight row based on cell value in two cells

Hi guys,

I am simply looking for a macro, which will highlight the whole row in yellow, if the cell in column J says Possible and at the same time the cell in column K says Priority 1.

Can anyone help me please?


Cheers,


Chris

You can use Conditional formatting for this. YOu don't need macro.

Select desired cells in row (I don't recommend WHOLE row) and use in CF:

Formula:

Please Login or Register  to view this content.