conditional format with color

[Techtrend]

The data is auto saved in excel the sample file is attached,
Need help in Multiple conditional format formula

 

[pecoflyer]

Personally I will not open a sheet to find out what you are trying to achieve. IMO that should be described in your post.Good luck with your query

 

[Techtrend]

what u mean by IMO

 

[pecoflyer]

In My Opinion

 

[Musupothers]

The first step in applying conditional formatting is choosing what kind of rule you want to apply. Click the dropdown menu at the top right corner of the dialog box and select “color scale.