Change formatting categorized by colour

Hi all,

I have an inventory appssheet, i wan to add colour for different category of storage condition.

How should i do it?

3X_b_e_bea9c3c58e200e506c89092040aa303ca69e266f.png

0 4 148
4 REPLIES 4

Please explore format rules

hi, yes i have read this,
but it change overall font colour, not with conditions.

For example:
Frozen = Deep Blue
Chilled = Green
Ambient = Red

Hi

Example below shown for โ€œFrozenโ€ . Please do select โ€œCategoryโ€ column in โ€œFormat these columns and actionโ€ setting.

Thanks. it solved my problem

Top Labels in this Space