changing row color based on value in cell

G

Guest

Hi

I am trying to do conditional formatting for an entire row, based on a value in a cell in that row. Basically, the fourth column in the row is a particular value, then the entire row should be highlighted. Can some one please give me suggestions

Thank you.
 
A

Andy B

Hi

Don't you like the options offered in misc. ? ;)

Andy.

haiiyaa said:
Hi,

I am trying to do conditional formatting for an entire row, based on a
Click to expand...
value in a cell in that row. Basically, the fourth column in the row is a
particular value, then the entire row should be highlighted. Can some one
please give me suggestions.
 
F

Frank Kabel

Hi
see your answers in Excel.misc
P.S.: please don't multipost as this fragments your answers
 

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

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
How can I automatically color a row based on cell content 1
Excel VBA 1
how do i change row font color based on cell value in that row 5
Excel Help to copy information from one row at a time to another sheet 1
Changing entire row based on 1 MAX cell value (Conditional Formatt 2
Highlighting the entire row with conditional formatting 10
conditional formatting based on relative cell value 2

Top