solution to fill color

I want to make a sheet with 5 columns (i.e. A1:E1) whose values control the value of other columns. For example, if A1=5 then the value of F1:J1 should be set to Blue, if B1=2 then the value of K1:L1 should be Red, etc.

or any other solution regarding same,

I am looking for a way to automatically and randomly fill in these color values, since the values may be different in each row.
color.jpg

No need a code : just use the Excel worksheet conditional formatting …

i think there is no such type of conditional formatting, can you please guide

This is why conditional formatting exists if your understand what means conditional word like formatting !

At beginner level : read the Excel inner help or any tutorial or ask a moderator to move your thread to the appropriate Excel section …

hey Marc thanks for your reply, but its different than conditional formatting, its not about only single cell, its about related to that particular cell and then fill to next cells, its something different, please go through my question and Image too,

Originally Posted by tamesh.d

if A1=5 then the value of F1:J1 should be set to Blue,
if B1=2 then the value of K1:L1 should be Red

Easy with a conditional formatting …