Hi,

Hope someone can help me with this problem - it is doing my head in.
Using Excel 2010 and trying to record a macro to complete conditional formatting on a specific cell range to fill the colour should a word appear in a certain cell.

Here is what I am trying to record but the VBA code just ignores it:

Select cell range: =$A$2:$Z$83
Formula: =$Z2="Review Pending"
Result: Fill row range Yellow

Select cell range: =$A$2:$Z$83
Formula: =$Z2="Validated Partner"
Result: Fill row range Dark Green

Select cell range: =$A$2:$Z$83
Formula: =$Z2="Declined Request"
Result: Fill row range Red

I have checked the coding from other posts but for the life of me I can't seem to get it to work.

Thanks in advance!