plzzzzzzzzzz help to get colour fill of a particular cell in a row to the entire row

[shailendra chari]

Can somebody help actually we have prepared rate analysis for more than 300 items. now there is a row in each analysis which i want to change for that i have made change by find replace in colour fill for that particular cell now i want to get that fill colour for the entire row where this cell is based. Hope u understand. Thanks in advance sir.

[etaf]

if you want a cell ro to change based on just one cell in the row, then use the $
=$A1= your condition

but I'm not sure i understand what you require ?

can you attach an example spreadsheet

[shailendra chari]

sir i have filled a cell with say yellow color now what i want is the entire row where this cell is based to have yellow color

[reimar_rem]

Hi,

How many colors you have?

Try this:

1.) Used filter, to filter color like for ex. filter yellow.
2.) So, all yellow in 1st column will appear, now you can fill yellow those filtered.

[shailendra chari]

sir i am attaching a file i want the fill for entire row

[etaf]

i cant help, i think you will need a macro to test the colour of the cells in the row and then apply the same colour when found

[reimar_rem]

hi

you can do it in filter. If few colors only better used filter.

see attachments.example22.xlsx

[shailendra chari]

yes it helped thanks a lot

[reimar_rem]

Hi

Your welcome...

Please click star * left below my post to add reputation

Thanks,

Reimar_rem