Forum Discussion
Conditional Formatting
Hello honkin !
To get rules in your Column A you can also check out the data rules in "Data" Tab- data tools - search for that icon i inserted you as screenshot.
Within that data review dialogue you have 3 tabs. in 1st tab you can select "user defined" and type in your already created formula.
Then you can switch to 2nd tab and define some information for your user what they must enter in that column. Finally on 3rd tab i recommend to block all other inputs that are not equal to your rule.
Hope that helps. Greets, Eva.
Thanks so much for your reply, Eva, but I don't think it is of any use in this instance as it puts restrictions on what can be input in the cells. That is not what is trying to be achieved. The other users in the office already know what to input and there are any number of possibly data inputs to go in each cell. I don't want to restrict what data goes in, just conditionally format what does go in
All that is required is for column A to change colour for any cell which meets the criteria listed in the formula and for this not to change regardless of data pasted into the column; so long as it meets the criteria, the cell changes colour. When I input my formula into the Data Validation section you showed me, absolutely nothing happens, even though there are cells which meet the criteria. Is this technique to be used in conjunction with conditional formatting? Otherwise I am not sure how the cells in column A will change colour.
Thanks for your reply