To set the whole row in a particular colo. (based on some conditio

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

Guest

Hi,
I was to set a particular color to a row based on some condition.

ForEx: if the value of a cell E5 is 'closed', then
set that entire row to 'grey' color.

How do I do that?
 
Use conditional formatting.

Select all the rows (let's assume it is E-M in this case).
Go to CF.
Change Condition 1 to Formula Is
Add a formula of =$E5="closed"
Click Format button and format as desired
OK out

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
HI,
The below solutionh was enouigh to set for a single row.

I selected some 5 rows and try to "Paste Special" with only the FOrmats of
that row. It didnt work.
 
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

Excel VBA 1
How to use conditional formatting for rows, based on info in cells 2
How to filter rows data based on background color of individual cells 1
Conditional formattion for whole row based on one cell value 3
Conditional Format a range based on 1 cell 1
Conditional format row based on 1 column. 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Row Deletion based on condition. 4

Back
Top