automatically reads cell colour

[silverskye787]

if cell B2 in highlighted in red, range C2:E2 will automatically highlight in red but if cell B2 is not highlighted in red, range C2:E2 will not be highlighted in red and remain unchange.

how do i do this? any formula?

 

[SteveO59L]

How is cell B2 highlighted in Red?

 

[silverskye787]

cell B2 is manually highlighted in red

 

[SteveO59L]

What causes B2 to be highlighted ?

If it is conditional on the value, you can do this with Conditional Formatting

 

[silverskye787]

cell B2 is highlighted based on user choice. if the user wish to highlight it, cell C2:E2 will be highlighted automatically as well.

can i know what is the conditional formula to be put in C2:E2?