Colouring Rows

  • Thread starter Thread starter matt_the_brum
  • Start date Start date
M

matt_the_brum

I have three columns, Possible, Lost and Won. In the rows I have list
of quotes and I put an x in whichever column describes that quote. Ca
I do something so that if I put an x in the Lost column the whole ro
goes red, if I put an x in the Won column the whole row goes gree
etc...?
Thanks for any help,
Mat
 
Hi Matt
you may use conditional formating for this:
- select the rows (lets assume you start in row 1)
- goto 'Format - conditional Format'
- enter the following formula
=$A1 = "X"
- choose a format for 'Possible'

- repeat this for the other two conditions. Formulas:
=$B1="X"
and
=$C1="X"
 
Back
Top