Colour Rows and Columns based on data validation

[holz_001]

Hi

I am looking to format my worksheet with different colours based on a data validation drop down list. I currently can get the drop down cell to be the correct colour but would like the whole worksheet (Columns B-J, Rows 2-67) to be different colours.

Any help will be greatly appreciated.

thanks.

 

[James006]

Hi,

There are several possible solutions ...

From your description, it looks like the easiest would be to use Conditional Formatting ...

see https://www.wallstreetmojo.com/conditional-formatting-based-on-another-cell-value/

Hope this will help

 

[holz_001]

thanks for this, however it only works to format each cell with the required text. I am looking to format the whole worksheet based on text in one cell.

 

[James006]

Hi,

If you input a Formula as a Rule in Conditional Formatting ... you can format the whole sheet ...