ExcelBanter - Conditional formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional formatting (https://www.excelbanter.com/excel-discussion-misc-queries/224694-conditional-formatting.html)

Conditional formatting

Hi. I have two data columns namely A showing numbers and B
classifying them into buckets like 0 - 30, 31 - 60, 61 - 90 etc. I
want to use the conditional format function in column B to change the
bucket as per the corresponding number cell in column A. How can I do
this? Can anyone help?

All times are GMT +1. The time now is 10:29 AM.