Conditional Formatting

[Arvind Shankar Raj]

Can the entire row be highlighted (colored) based on a color of a cell ??

for example if A10 is RED... then I need to highlight the entire row A in YELLOW, if A10 is GREEN... then entire row A in BLUE.

Please help...
Regards,
Arvind

 

[Hui]

Arvind

Firstly, Welcome to the Chandoo.org Forums

The quick answer is yes, but not as you expect

Can you tell us what is the logic behind the colors in A10?
If it is simply that the cell is marked Red by a user, that can be done
If it is that the cell is Red by use of Conditional Formatting, it is very difficult to access the CF colors of cells, but the logic to the CF colors can be replicated in the other cells

Can you please attach a sample file and answer the questions above

 

[Arvind Shankar Raj]

Arvind

Firstly, Welcome to the Chandoo.org Forums

The quick answer is yes, but not as you expect

Can you tell us what is the logic behind the colors in A10?
If it is simply that the cell is marked Red by a user, that can be done
If it is that the cell is Red by use of Conditional Formatting, it is very difficult to access the CF colors of cells, but the logic to the CF colors can be replicated in the other cells

Can you please attach a sample file and answer the questions above

Thank you Hui.

I am using Conditional Formatting to find blanks in a column. If there are any blanks in a column... then I want the whole row to be highlighted in a different color.

please help

 

[Nebu]

Hi:

Find the attached.

Thanks

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan