Hi all,

I need help to format a row of data given the input of a specific letter in a specific cell.

For example, in Column W i have a decision to make: Yes, Maybe, No.

Depending on the letter I write in this cell, (Y for yes, M for maybe, and N for no), i would like the following to happen:

Y formats the row, column C to L, GREEN
M formats the row, column C to L, YELLOW
N formats the row , column C to L, YELLOW

The letter i'm writing in always in Column W for the corresponding action to be taken on that row.

I've tried using conditional formatting function, but I think this requires a VBA.


Thanks!!!!