Posted to microsoft.public.excel.programming
|
|
HOW CAN I APPLY CONDITIONAL FORMATTING BASED TO AN ENTIRE ROW?
Some additional resources for conditional formatting:
http://mcgimpsey.com/excel/conditional6.html
http://www.xldynamic.com/source/xld.....Download.html
"James M" wrote:
Fantastic! I knew it had to be something simple.. If I have more conditions,
do you have any ideas?
Also, I know this odd but is there a way of doing this in reverse?... i.e.
if it is green insert a "b"?
J
"bpeltzer" wrote:
Assuming you have three or fewer conditions, then conditional formatting can
handle this. In A20, for example, set the first CF to read 'formula is'
=$I20="B".
You can fill this across and down. Additional conditions can be applied
just like normal.
"James M" wrote:
I have a reasonably large spreadsheet (about 2000 rows) and i need to format
each row based on the value of a cell in a specific column.
For example, if there is a "B" in Cell I20, I need to fill the whole of Row
20 with the colour green. I then need to apply this to every row.
Similarly if there is a different letter, I need to make the row a different
colour...
All help gratefully appreciated!
J
|