I need to format multiple cells based on multiple conditions: 1. Format cell AM6 based on the value in column L6 (format AM6 if $L6="No"), copy down AM column 2. Format cell AN6 if $M6="No" 3. Format cell AO6 if $J6="No" 4. Format cell AP6 if $N6="Yes" 5. Format cell AR6 if $U6="No" 6. Format cell AU6 if $S6="No" 7. Format cell AV6 if $T6="No" 8. Format cell AX6 if $V6="Yes" 9. Format cell AZ6 if $W6="Yes" 10. Format cell BA6 if $X6="Yes" 11.Format cell BB6 if $X6="Yes" 12. Format cell BE6 if $Y6="Yes" 13. Format cell BG6 if $AB6="Yes" 14. Format cell BH6 if $AB6="Yes"
Solved by K. H. in 22 mins