how do automatically change entire row color when cell changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
is it possible to change the color of the row cell1 is in when cell1 changes
to a specified text?
 
Hi
- select the row (e.g. row 1)
- goto 'Format - Conditional Format'
- enter the following formula
=$A1="Text"
- choose your format
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Question 2
DateDif Question 6
Convert formula to value based upon date 3
Using a value from a cell inside a formula! 5
Inserting additional rows and only copying certain columns 1
Determine if time is within a windoww 2
populate month-yyyy when compare 2 cells 3
merging cells together but keeping all data from the cells 3

Back
Top