Forum Discussion
Date Checking custom rules
Good afternoon everyone. I have a question and wonder if you could help please. Below is an example of a spreadsheet im running Basically what I need to do is (ideally) highlight cells A...
HansVogelaar sorry another question for you!
This worked perfectly, you're a star!
I would like to create a 'key' so people know what the colours mean. Is it possible to do, or do i do it manually? Also, is it possible to have it so it's visable wherever you scroll? I did put it in column A so i could freeze top row and first column, but column A is only visable if i scroll A-Z, but i'd like it visable as i scroll further down the worksheet (row 100+)
any ideas?
You'll have to create the legend (or key) manually.
You might insert a few empty rows at the top, and create the legend in A1:A5 (fill color as in the conditional formatting rules, description as cell text).
Then freeze the top 5 rows and left column: