conditional formatting

  • Thread starter Thread starter tom donino
  • Start date Start date
T

tom donino

I want to fill a row with color given certain conditions.
For example, row 10 has triggered my criteria which are
in F10, N10, N11. How can I format the sheet to color in
row 10 a certain color?
 
Hi
try the following:
- select row 10
- goto 'Format - Conditional Format'
- enter the following formula
=($F10="condition1")*($N10="condition2")*($N11=condition3")
- choose a color
 
Back
Top