Windows XP Format a Cell based on another cell Value

M

mpena23

Joined
Nov 11, 2008
Messages
1
Reaction score
0
Hello

I want to apply a format to a line based on an input, let's say I have 5 rows and 5 columns of data I want that if I type "x" in the column number 6, lets say "F1" the format of row a1 to e1 change and so.

it's there any way to do that in excel, or a macro that identifies in all the cells that I've typed "x" and format the corresponding lines?

Thanks

Miguel
 

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

Format one cell in a row based on value of another cell in that ro 1
How to set cell value to emptry if three other columns are empty too 1
Adding fill to cells only when value is "No" in another cell 1
Excel Can you lock the value of a cell but not the format? 1
Conditional Format based on Month of Date in Cell 1
Conditiona format based on format of another cell 1
conditional formatting based on the value of another cell 8
Filter out rows based on the value of a cell 4

Top