How to change background color based on first row value?

[putritersenyum]

Plese, help me to change background of rows 2 to 10 based on first row value. I have columns A to J.
If the value on the first row of certain column contains certain value so the cells of row 2 to 10 change to red. I hope there are some formulas to change it automatically from Conditional Formatting.

[BadlySpelledBuoy]

Have a look at the conditional formatting formula in the attached.
It will turn the relevant cells red if X is entered into row 1.
You can obviously adapt the formula to reflect the value you need.

BSB

[Pete_UK]

Select all the cells from A2 to J10, then click on Conditional Formatting | New Rule | Use a formula... , then put this formula in the dialogue box:

=A$1=1

You will need to change the 1 in red above to your "certain value". Click on the Format button | Fill tab and choose red then OK your way out.

Hope this helps.

Pete

[samba_ravi]

select A2:J10 and use below formula in conditional format

A$1="YOUR VALUE" AND APPLY FORMAT

[putritersenyum]

I have multiple values, please help me to add the others on the formula

[BadlySpelledBuoy]

If you have a small number of values you could use OR in the formula:

Please Login or Register  to view this content.

If you have a larger number of values then put them in a range and use a COUNTIF formula:

Please Login or Register  to view this content.

BSB

[BadlySpelledBuoy]

Sheet1 in the attached demonstrates the OR method.
Sheet2 demonstrates the COUNTIF method, where the range it compares with is the yellow cells.

BSB

[putritersenyum]

@Pete_UK & @nflsales thanks for the advice it works.

@ BadlySpelledBuoy
Thanks very much it works well for the multiple values.

[BadlySpelledBuoy]

Happy to help. Thank for the rep point

Don't forget to mark the thread as SOLVED if you're happy you have a working solution.

BSB