Forum Discussion
Conditional Formatting Formula
Greetings! I would like to ask your suggestion on what formula should I use in conditional formatting to show number of rows based on the number I input in data validation cell. Kindly refer below f...
Assuming you have Excel 365 and can use SEQUENCE as HansVogelaar suggests, the conditional formatting can be based on the month number
= ISNUMBER($A6)
Okay. Thank you very much.