1-179 red and 180-269 no color 270-300 green

[dagwood15t]

how can i set up my colum to do this 1-179 red and 180-269 no color 270-300 green

 

[al_b_cnu]

Hi,

Try conditional formatting.
For Condition 1, set 'Cell Value' ' Between' 1 and 179, click the [Format] button & select red from the 'patterns' tab.
Click [Add] button for condition 2, etc.

 

[arthurbr]

Welcome to the board
Format - conditional formatting - Select "Formula is"

=row()<180   color1
=and(row()>=180,row()<270) color 2
=row()>=270  color3

 

[wudhus_kid]

I don't really understand your question, but it sounds like conditional formatting - Format menu\conditional formatting

Enter the parameters, i.e., value between 1 & 179, then set the format if this is true.